Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)
I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions
Should Microsoft be worried that Salesforce has just acquired Slack? In my opinion – YES, in fact it should be so worried that it must double its investments in Power BI.
in this video I talk about the fatal flaw of the Power BI's Filter pane and how we can fix it with breadcrumbs. What fatal flaw am I talking about? What the heck is a breadcrumb? Well, watch the video and you will find out. https://youtu.be/6HHbPzqhcn8 These are the measures that I have created to … Continue reading Power BI & DAX: How to Use Breadcrumbs to Fix the Fatal Flaw of the Filter Pane
I find it interesting that after it's been out for a long while, and after some great attempts by non-Microsoft sources to provide an adequate definition, I am still struggling with being able to provide a succinct explanation of what Power BI is to my customers. My best attempt thus far has boiled down to … Continue reading What is Power BI?
If you used pictures in your Power View dashboards and tried to deploy these dashboards in your Power BI tenant you are likely to have seen the following warning message: "UNSUPPORTED FEATURES External pictures can't be displayed in Power View Sheets in Office 365". My guess it's only a matter of time when external pictures … Continue reading How to Use Pictures in Your Power BI Power View Dashboards
I am very excited to report that as of few days ago, the HTML5 engine for Power View has closed some major gaps with the Silverlight Power View engine. In February of this year I wrote a post comparing various Power View artifacts between Silverlight, HTML5 and Power BI Windows 8 App. At the time, … Continue reading HTML5 Engine for PowerView Getting More Updates
Time for another correction… A couple of months ago I wrote a post about how to load data into a Power Pivot model using Power Query. As I was writing it, I was very excited about being able to decouple my Power Pivot models from physical data by using Power Query. Unfortunately, at a time, … Continue reading Date Management Gateway Now Supports Refresh from Power Query
On April 18 Power Map got updated, although if you have a Click-to-Run installed version of Office 365 Pro, you would never know it since these updates are pushed automatically. Here is a link describing the new features, other than some cosmetic updates, ability to add audio to a tour is probably one of the … Continue reading April Update for Power Map Adds Audio, Clears Confusion
I have been getting some questions about it recently so I decided to write a few lines in addition to what's now available on the Power BI site. Here is a list of some key points about the tool: No middle-ware components are necessary to provide the connectivity between Excel and the Business Objects server. … Continue reading What is the Microsoft Power BI connector for SAP?