How to point existing reports to a new dataset in Power BI (even from AAS)
One question that comes up regularly is how to point an existing report to a new dataset. There are quite a few reasons why you... Read more
Category: Power BI
Setting up translations for datasets in Power BI premium
One request that comes up a lot is to be able to provide translations for the tables and columns of your model (especially here in... Read more
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
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