Debug Power BI aggregations with DAX Studio
A quick post today. Sometimes you will be mystified why your aggregations are not getting hit. There is no clear-cut answer to why. The best... Read more
Category: Power BI
How to change the dataset script in Power BI desktop
I recently on some internal email by the developers where they mentioned something, offhand, what I think is amazing :). It will allow you to... Read more
Dynamic formatstrings with Calculation groups
One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply... Read more
Adding calculation groups to (A)AS or PBI Premium
I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be,... Read more
Get the SQL Query used in DirectQuery mode
When you are optimizing your DirectQuery model and you have done all the optimizations on the model already, you might want to run the queries... Read more
5 reasons to use aggregations in Power BI
A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys... Read more
Power BI and the year 2019 in review
As the end of the year closes I was reminiscing on what a huge year it has been for Power BI. I work mostly with... Read more
Building a dataculture with Power BI
I meet a lot of customers in my job, either through the Microsoft field or at conferences and many times we hear the same: “We... Read more