thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Foundational

Power Query

Microsoft's data connection and transformation engine, used in Power BI, Excel, Dataflows and Fabric, with a GUI that records steps as M code.

Definition

Power Query performs ETL tasks such as filtering, splitting, merging, appending, pivoting and unpivoting, type changes and profiling. Each transformation is an applied step, and queries that fold run on the source.

Exam tip

Shape data in Power Query (or upstream); calculate in DAX. Push transformations as far upstream as possible.

Related terms