Forum Discussion
Solved
Query folding Import mode
does query folding happens in case of import mode? if yes then those transformations happens at source or inside power bi memory?
Query folding still works in import mode, so it's important to apply foldable steps first. For example, filtering rows and removing columns can be pushed to the source. Do those steps early, before adding any that stop query folding. Power Query will show a warning when a step breaks folding.
Yes query folding can still happen in Import mode, but only during the initial data load or refresh. If folding is possible, the transformations get pushed to the source system, not Power BI memory.
Once the data is loaded, Power BI stores the result in memory, and transformations don’t fold anymore it’s all in-memory after that. So folding helps optimize the load, not the in-memory model.