How to speed up your Power BI Reports by adding multiple aggregation tables. This video walks through how to configure and test multiple aggregation tables.
You are amazing Phil! Now, I have only a few issues. I've got different granularity and i'm using Google BigQuery (i know its shit, not my choise) so cannot use Dual storage mode, either DQ or Import. So i'm creating imported agg tables using PowerQuery with a daily refresh. The Fact table is in DQ mode. However i'm struggling with the shadow model, it just does not hit / fails. Does my DIM-table have to be in Dual for this to work? Can you also make a video for Shadow model based on let say both month an different higher graunularity of product dimension such as "colors" instead of a spesific one. Say my Dim table has more than 120k rows and fact has over 2 trillion.
Wonderful. This improved the speed of my report a lot. Thank you
Great Videos My friend.... I hope you continue what you do
Love it, thank you very much! 🙏🙏
Just a quick tip: You do not need to set relation to tables on Model page (like one to Many or what else). It already works.
It’s failing if I am using distinctcount in my measure.
You are amazing Phil!
Now, I have only a few issues.
I've got different granularity and i'm using Google BigQuery (i know its shit, not my choise) so cannot use Dual storage mode, either DQ or Import. So i'm creating imported agg tables using PowerQuery with a daily refresh. The Fact table is in DQ mode. However i'm struggling with the shadow model, it just does not hit / fails. Does my DIM-table have to be in Dual for this to work?
Can you also make a video for Shadow model based on let say both month an different higher graunularity of product dimension such as "colors" instead of a spesific one. Say my Dim table has more than 120k rows and fact has over 2 trillion.