In Power BI, what does ‘query folding’ mean in Power Query?

Question

Power BI — Medium

In Power BI, what does ‘query folding’ mean in Power Query?

Accepted Answer

Query folding in Power BI's Power Query refers to optimizing data processing by delegating transformations to the source database. This approach reduces local processing, enhancing performance. The correct answer, pushing data transformation steps back to the source database, is accurate because it describes this process. Other options are incorrect as they describe unrelated concepts, such as combining queries or caching results.