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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
richard-powerbi
Post Patron
Post Patron

What transformations are allowed in Direct Query?

Is my feeling correct that all transformations are allowed to a DQ as long as Query folding takes place? Is this the way to find the limits of what can be done?

1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

@richard-powerbi 

sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

4 REPLIES 4
az38
Community Champion
Community Champion

@richard-powerbi 

sorry, correct link https://docs.microsoft.com/en-us/power-query/power-query-folding


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

I guess this is the answer in your link that confirms:

DirectQuery and Dual storage mode tables: Each DirectQuery and Dual storage mode table (Power BI only) must be based on a Power Query query that can be folded.

@richard-powerbi 

But there are some limitations in the second link 🙂

Transformations that prevent folding
Generally, the following list describes transformations that prevent query folding. This is not intended to be an exhaustive list.

 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
az38
Community Champion
Community Champion

Hi @richard-powerbi 

not sure https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#limitations-of-direct...


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors