Forum Discussion
Visual initial loading time retrieval
hi desperate need help
I have a report that connects to a database in DirectQuery mode. However, the file is large (9 MB). When users first launch the report, the three visuals show as empty with continuous loading icons and take several minutes to appear. Is there a solution to reduce the initial loading time to 1–2 seconds? I cannot modify the DAX measure and Direct query because I will get blamed. How can I achieve an initial loading time of under 2 seconds if the relationship remains active?
this is how it works
When the relationship is active, the initial loading of these 3 visuals in Power BI takes 1 minute.
When the relationship is inactive, the initial loading takes 3 seconds.
How can I achieve the initial loading of under 2 seconds if the relationship is active?
1 Reply
- Praful_Potphode
Super User
Hi CU08101843
we cannot bring the loading time down all of sudden.below are some of the best practices that you can follow in your model.
- try to change storage mode of your powerapp table to import.
- use performance analyzer to identify which visual is loading slow.if its table with 23 column then reduce the columns in landing page so that it loads fast.create a drillthrough page which has all 23 columns.
- try to save your report with default filters applied so that data load is less which in turn improves visual load time.
Please give kudos or mark it as solution once confirmed.
Regards,
Praful
