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

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

PowerQuery: Staging steps

It would be really good to have some staging \ caching ability when designing queries.

 

Sometimes you are designing a complex query that reads a lot of data and is generally slow. Currently at every action power query re-reads all the data on every action, even on ones that do not really need a full refresh - like renaming\reordering columns, adding columns with no calculations etc. Even renaming a step triggers a full refresh which can take up to several minutes. 

 

It would be nice if I colud "Freeze" a step basically telling that it needs to be cached and no data is to be refreshed before this step while designing the query. 

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

You may share feedback via Ideas to help improve Power BI.