Forum Discussion

Kolyckaa's avatar
Kolyckaa
Frequent Visitor
4 years ago

Visuals take long time to load with Direct Query dataset

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!

Tips and Tricks

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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.