Forum Discussion
Matrix Performance
Hey, so i'm working with a dataset that has over 440 million rows. I cant import it so I've been using Direct Query. The issue I'm running into is that my managers want around 15-20 measures (total s...
Anonymous
There is no way to maintain the performance if you use measure, my suggest would be to convert some measures into columns, so the power bi pre-calculates the result when you open the pbix instead of calculates when creating matrix visuals.Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Community Champion
Community ChampionAnonymous - I would recommend looking into Aggregation Tables. https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations#:~:text=The%20aggregation%20feature%20interacts%20with%20table-level%20storage%20modes.,non-multidimensional%20DirectQuery%20data%20sources%20can%20work%20with%20aggregations.