Maxim on 06 Jul 2020 19:35:29
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 renamingeordering 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.