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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

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.