Power Query

Learn how to use List.Generate in Power Query to loop through APIs. Repeat API calls until your condition is false. Works with pagination!

List.Generate is an advanced Power Query function that creates lists. It allows you to implement iterations and has similarities with loops.

Over the past few years I’ve blogged and presented extensively on the subject of Power Query’s data privacy settings (see here for a post with links to all this content). I thought I kn…

A while back, I was working on a project involving getting data from Excel files. The Excel files contain the data in sheets and tables. Getting the data from the tables is easy. However, the data in the sheets have some commentaries on top of the sheet, then the column names and then the data … Continue reading Combining X Number of Rows in Power Query for Power BI, Excel and Power Query Online

If you’re working in Power BI Desktop you may sometimes find that your visuals error with the message “Couldn’t load the data for this visual. The operation was cancelled because …

Complete Guide to Lists in Power Query. Learn how to Make Use of the Most Powerful Power Query Functions (And Master Them).

When you build a date table in Power Query you might use the functions under Date to add year, month and day And this will give you three steps in your Query But we can do this a bit faster, and yo…

There are over 600 functions in Power Query. Yet, those functions won't always do what we need, therefore we might need to turn to custom functions.

This article discusses how to create a custom functions in Power BI using Power Query. The latest SQL Server articles from SQLServerCentral

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

An article that covers how in depth how the Combine Files experience in Power BI / Power Query and how parameters and functions work inside of it.

Understanding the main principles of Parameters and Functions in Power Query and Power BI when it comes to Data Preparation and the M language.

How, when and why to use recursive functions within Power BI / Power Query. Theoretical and practical examples

There’s a nice new feature in Power Query Online (the version of Power Query used in Dataflows): parameters of type List. You can see this as a new option in the Type dropdown in the “M…

Learn about new Power Query-related updates in the recent October 2021 release of Power BI Desktop!

Here is a tip that reduces your Power Query steps with 1 step less. When I build date tables I typically use the function List.Dates to create a list of dates. As I want it as a table I use the Rib…

This article shows how to get the previous row value using Power Query. You can adjust the 3 ways to also retrieve an earlier or later row.

Learn how to create a dynamic date table in Power Query. Make sure to pick up your free script to generate a reusable calendar.

Last year I blogged about handling multi-select scenarios for dynamic M parameters. Since then support for “Select All” has been added (see here) but since a regular slicer with no item…

learn how to transform a status log table with one date column to a from and to date column based table using Power Query in Power BI.