Forum Discussion
Power BI visuals taking long time to load
Hi,
I have a collection of reports in a pbix file running in direct query mode.
Out of all, two visuals taking long time(10-15 mins) to load.
The actual query in sql server takes 3 secs to get the rows. I have deleted all the unwanted measures, recreated measures, deleted & reloaded the table in PowerBI. I still have the same issue in both PowerBI desktop & service.
Is there anything else I have to do? Please guide.
Thanks!
3 Replies
- v-piga-msft
Resident Rockstar
Hi SR1,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
- Greg_Deckler
Community Champion
Extremely difficult to troubleshoot from afar. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET". - v-piga-msft
Resident Rockstar
Hi SR1,
Firstly, please check if you have installed the latest version of Power BI Desktop(2.65.5313.1381).
In addition, what two kinds of visual do you use?
If your calculation in power bi is complex, it will casue load slowly.
In addition, you could have a referece of this atricle about Power BI Performance.
Best Regards,
Cherry