by Matt Allington | Apr 25, 2017 | Excelerator BI
A client contacted me recently and asked me to solve a problem for them. They have a large Power Pivot Excel workbook with lots of Pivot Tables. All was good except sometimes when they refreshed the data, the newly loaded data changed the shape of some of the pivot...
by Chris Webb | Apr 25, 2017 | Chris Webb
The Add Column By Example functionality that appeared in the April 2017 release of Power BI Desktop is, I have to say, very cool: I’ve used it quite a bit in the last few weeks and it really does work well. One thing I noticed while using it is that three new...
by Melissa Coates | Apr 23, 2017 | SQL Chick
The Cortana Intelligence Gallery is a site where you can search for solutions, tutorials, experiments, and training for learning the data & analytics tools within Azure. The Gallery can be located at: https://gallery.cortanaintelligence.com/. This post first...
by Gil Raviv | Apr 21, 2017 | Data Chant
Power BI Custom Visuals have recently moved to Office Store. You can now find them here. To celebrate the occasion in a typical DataChant way, I have used the web scraping techniques that I had recently shared here and here, to prepare a Power BI report that...
by Chris Webb | Apr 18, 2017 | Chris Webb
If you’re building reports in Power BI against SSAS Multidimensional cubes then you may have encountered situations where the formatting on your measures disappears. For example, take a very simple SSAS Multidimensional cube with a single measure called Sales Amount...