Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Visuals are loading extremely slow

Not sure if this is the right place to post this so mods please move this to the correct area if necessary.

I currently have a 9 page dashboard.

8 out of the 9 pages load reasonably quick (could be better) but the last page seems to take 40-50 seconds to load completely after it has been inactive for a while.

Most of the pages have minimal measures except for the last page which has a bunch of measures used in the visuals although I don't think they are relatively complicated measures and shouldn't cause the visuals to load extremely slow?

The data is not loaded through any form of powerquery, it is just through a few csv/xlsx files (approx. 500-600mb) in size. 

What could be causing the slow load times for the visuals? I have attached a performance analyzer .json file 

Performance Analyser JSON  

4 Replies

  • az38's avatar
    az38
    Community Champion

    Hi Anonymous for me access to your log-file is denied

  • aj1973's avatar
    aj1973
    Community Champion

    Hi Anonymous 

    Many measures with many conditions and filters in a same visual and or in the same page could cause the issue.

    a DAX analyser could detect which measure take long time to load. 

    Your Jason file isn't accessable.

     

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    One page with many visuals may also make your report loading slow. Please appropriately reduce the number of visualizations on one page.

    In addition, you can refer to these documents to find which visuals slower:

    Use Performance Analyzer to examine report element performance;

    Introducing the Power BI Performance Analyzer.

     

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.