Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
seafish
New Member

Slow Power BI report despite fast query in SSMS

‎10-22-2018 11:13 AM

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?

Message 1 of 2
1,379 Views
0
1 REPLY 1
v-chuncz-msft
Community Support
Community Support

‎10-29-2018 12:57 AM

@seafish,

 

You may take a look at Guidance for using DirectQuery successfully.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 2
1,375 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All