Power Query

Power Query

Data transformation and preparation for Power BI — connect to sources, clean data, and shape it with the M language.

Power Query

Power Query is the data transformation engine behind every Power BI model, handling everything from connecting to a source to producing the clean, well-typed tables a report is built on.

Source Data
     |
     | Power Query
     |
Clean, Modeled Tables
     |
     | loaded into
     |
Power BI Data Model

Start Here

Introduction

What Power Query does, and where it fits in a Power BI model.

Power Query Editor

A tour of the Queries pane, preview grid, and Applied Steps.

Transformations

Common transformations for cleaning and reshaping data.

Merge Queries

Combine tables on matching columns, and choose the right join kind.

Query Folding

How Power Query pushes work back to the source for faster refreshes.

Want to work with the underlying formula language directly? See M Language.

Many-to-Many Relationships

How to model many-to-many relationships in Power BI, and when to use a native relationship versus a bridge table.

Introduction

An introduction to Power Query, the data connection and transformation engine behind Power BI.