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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Prevent Direct Query with Running full SQL Statment

when creating a Direct Query dashboard I need to connect to big a complicated SQL query that will be filtered  (by defenition) by the user. the SQL Statment disent load, I get a timeout - why does it run the full query? 

again- the query is complicated and huge, but when the user will filter it (WHERE statment will be added by PowerBI) it will reduce to very small result.

 

Is there a way to prevent PoerBI with running the full query when I load the SQL statment to the dashboard?

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

This issue depends on the sql statement and transformed native sql statement. I would suggest you read the doc about query foldering:

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

This issue depends on the sql statement and transformed native sql statement. I would suggest you read the doc about query foldering:

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.