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.
Hi,
I have a Power BI report using DirectQuery where the query finishes in under 1 minute. Howeve, the single matrix visual contained in the report takes 7+ minutes to load.
After I add a slicer and make selections on the slicer, the report takes an additional 1 minute to display the selections in the slicer, and it is taking forever to refresh the matrix visual.
The underlying data source contains about 7000 records.
This same report runs instantly when connected to a local excel data source with the same amount of data.
What causes the slowness of this report in Power BI when querying directly from SQL server? What could be done to make this faster?
You may take a look at Guidance for using DirectQuery successfully.
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |