Visuals take long time to load with Direct Query dataset

[Kolyckaa]

Hello everyone,

I have a PBI report running in direct query mode because I have a lot of tvf used. 
Some visuals taking long time(10-15 mins) to load.
The actual query in sql server takes just a few 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.

Caching is not supported with Direct Query dataset. 

Thanks!

[lbendlin]

Use the Power BI Desktop Performance Analyzer to grab the query for the offending visual and then analyze the query plan for that query in DAX Studio. Specifically look for excessive number of records. Then optimize the query/measures as needed.