Skip to main content

Power Query for Power BIs

Power Query is the data connection and transformation layer in Power BI. It pulls data from files, databases and web services, then records each cleaning step in the M language so the same steps replay on every refresh. It sits at the start of the pipeline, before the model and DAX.

Stage: Data Preparation · Part of the Power BI roadmap · Last reviewed 19 November 2026

What to learn in Power Query

Power Query interview questions

What is the difference between merging and appending queries in Power Query?

Merge joins two tables side by side on matching key columns, like a SQL join, and adds columns. Append stacks tables with similar columns on top of each other, adding rows. Use merge to enrich data and append to combine monthly files.

What is query folding and why does it matter?

Query folding means Power Query translates your transformation steps into a single native query, such as SQL, and runs it at the source. It matters because the database does the heavy work and refresh is faster. Some steps break folding, so order them carefully.

Where Power Query fits in the Power BI roadmap

Power Query belongs to the Data Preparation stage (beginner level), which takes about 14 hours. Connect and clean.

Back to the full Power BI roadmap