Power BI visuals taking long time to load

[SR1]

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!

[v-piga-msft]

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

[v-piga-msft]

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

[Greg_Deckler]

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".