Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
scoobyloong
Frequent Visitor

Direct Query taking unreasonably long

Hi everyone, this is my first post so i'm not too sure if i'm in the right page. 

 

My dashboard currently uses direct query to filter through 2 scenarios (out of a list of a 1000+) and obtain rather granular data that spans into the thousands of rows. It seems that applying a hard filter in power query to limit the query on power query to a list of 2 scenarios, there is a substantial speed up of about 10x. 

 

Basically i'm trying to calcaulte percentiles of data that is halfhourly as a measure, but it seems that DAX/Powerquery iterates through all scenarios on a halfhourly level to check if it belongs in that scenario, explaining why the query is so slow. 



1 REPLY 1
v-juanli-msft
Community Support
Community Support

Hi @scoobyloong 

DirectQuery is a direct connection to data source. Data will NOT be stored in Power BI model.

Power BI will be a visualization layer, then query the data from data source every time.

 

In the DirectQuery case, when users visit a Power BI report, Power BI sends queries in real time to the underlying data source.

Once the data source returns with the query data, then the report is rendered.

As a result, your report performance in these cases depends largely on the performance of the underlying data source.

Learn more about performance:

Power BI performance best practices

 

You could Use Performance Analyzer to examine report element performance

 

With DAX Studio, you could analyze DAX queries for performance issues, and  improve the writing of DAX queries.

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors