Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.