Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action
Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly you need to create an aggregation table, secondly, you need to set up proper storage modes for tables in the model. Finally, you have to configure the aggregation functions, which is what I’m going to explain in this post. You can learn about aggregation in other posts of this series, and continue the example here. If you like to learn more about Power BI, read Power BI book from Rookie to Rock Star.
What is aggregation in Power BI?
Step 1: Create the aggregated table
Read the rest of the article here: https://radacad.com/power-bi-aggregations-step-3-configure-aggregation-functions-and-test-aggregations-in-action
Senior Technical Solution Architect at Hitachi Solutions Europe leading innovative data solutions
6 å¹´Vanessa Robinson this may help out the performance of that direct query dashboard :)