Go to content
We are the #1 Microsoft partner of the Netherlands

Power Query (English)

2 days


Do you use Power BI to load data yourself, but is it time for the next step? With Power Query (part of Power BI) you can explore data from the most diverse sources and formats, assess data quality, retrieve, transform and load it into the Power BI data model.

Power Query supports over 350 different types of data transformation. You can usually set this up via the graphical interface, but Power Query also supports the use of functions, *custom columns* and directly entering or modifying the M code in the Advanced Editor.

In this two-day training we look at the best way to import, transform and load your data using Power Query and M (the language of Power Query). We work hands-on with data to create queries that have added value for your organization.

We look at both classic Power Query for Desktop that you know from Power BI Desktop and Excel, and at the more modern variant Power Query Online , which is used in Power BI dataflows, among other things, via an internet browser.

Prerequisites to follow the Power Query training

To be able to follow the Power Query training, it is important to be well versed in Power BI. For example, you may have acquired this prior knowledge in the Power BI: Self-reporting and data analysis training (PL-300 / PL-300T00) , or our Power BI + DAX learning path .

As a participant you need access to Power BI Desktop on your own work laptop.

Course outline

We go into depth, in theory and practice. We look at the following components:

  • Place of Power Query Editor in Power BI (Source Power Query DAX)
  • data sources
  • Data transformations
    • merge
    • Append
    • AI insights
    • custom functions
    • columns from examples
  • advanced editor
  • using Lists, Records and other data types
  • performance tips
  • Diagnostic tools
  • Data preview capabilities
  • query dependencies
  • staging queries
  • query groups
  • parameters
  • duplicates and references
  • Power BI Dataflows

Study material

In the Power BI - Power Query training we use material that we have developed ourselves at Wortell Smart Learning. This is material with many exercises and cases from practice. We make sure that you receive all the necessary material on time. The end result of all exercises is available.

Available dates

There are currently no scheduled dates available. Please contact us for options.