Optimizing Performance for Power BI Reports with Large Datasets and Complex Measures

Hi MicrosoftMaster,

I think this should be a normal loading time based on your report data amount, calculations and design.
Is it possible to reduce the stored data amount and calculation fields? Or you can try to switch to live connection mode and put the Dax expressions to the database side?

Regards,

Xiaoxin Sheng

Hi,

Thank you for your suggestion. Unfortunately, I’m unable to reduce the stored data amount or move the DAX expressions to the database side. As per our team's procedures, all measures must remain in the dataset, and we use a live connection for our reporting setup. This approach ensures consistency across multiple reports and datasets.

If you have any alternative recommendations that work within these constraints, I’d be happy to explore them!

Anything above 5 seconds leads to bad user experience.  Continue learning about how to use DAX Studio to optimize your measures (SQLBI.com has tons of training videos on that topic). Refactor your queries so they use fewer resources.