Report performance issue

[eijer]

The report is taking a long time to turn off the screen after 'loading data'.
The amount and modeling of data may vary, but thousands of data also take more than five seconds.
Please let me know how you can monitor performance, server settings to improve performance, Power BI Desktop settings, and more.

If you have any explanatory material on the execution mechanism from data loading to screen rendering when running a report, please send it with us.

Thank you so much.

[KBO]

Hi @eijer ,

you can use diefferent things to monitor:

1) Performance Analyzer (https://docs.microsoft.com/de-de/power-bi/desktop-performance-analyzer/ https://www.sqlbi.com/articles/introducing-the-power-bi-performance-analyzer/

)

2) DAX Studio - to check your measures (https://www.sqlbi.com/tools/dax-studio/)

3) Analyzer in Power Query - to check the load (https://docs.microsoft.com/en-us/power-query/recordingquerydiagnostics)

And of course Guy in the Cube:

https://www.youtube.com/watch?v=VlP1_Ic9qaw (That is only one video ;))

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!