Forum Discussion
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 f...
lbendlin
Super User
Super UserUse 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.