Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.
     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.