Data loading and manipulation with Power Query

Power Query is the data loading engine inside Power BI (and also Excel 2016+ and SQL Server Analysis Services Tabular models), and M is the language behind Power Query. On this 3-day workshop you’ll get a comprehensive introduction to all of the functionality of the Power Query engine, including how to connect to data sources and output data in a format suitable for your Power BI dataset. You’ll also learn about the M language and also new features such as dataflows.


Day 1

  • Data loading and transformation basic concepts: Power Query, queries and steps
  • Connecting to different data sources: text files, Excel files, relational databases, web services and web pages
  • Using the UI to transform data and add new columns
  • Working with multiple queries
  • Best practices for loading data into Power BI

Day 2

  • Using parameters
  • Introduction to the M language
  • Using functions to combine data from multiple sources
  • Solving problems with M code
  • Taking advantage of query folding
  • Data privacy and the formula firewall

Day 3

  • Working with web services in M
  • Performance tuning and diagnostics
  • Using dataflows for advanced data preparation
  • Using Power Query in Microsoft Flow
  • Creating and using custom data connectors in M



Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of “Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model”, “Expert Cube Development with SQL Server 2008 Analysis Services”, and “MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase”, and blogs at

Copyright 2019 Orange Man · RSS Feed · Log ind · Google+

Organic Themes