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
- Connect Power BI to an Excel file, a SQL database and a web source
- Remove duplicates, fix data types and split columns using the Query Editor
- Merge two queries with a join and append tables with the same shape
- Unpivot a wide cross-tab table into a tidy table
- Read the Applied Steps pane and edit a step in the M formula bar
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.
Other units in this stage
Back to the full Power BI roadmap