Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |