PowerQuery

How to process multiple folders with a single PowerQuery script

Let us imagine the following scenario. We have multiple clients sharing their sales data with us. They store the data in dedicated folders that reside in different places. The number of clients, as well as the number of files for each client, will vary across periods. We wish to create an automatic refresh system that …

How to process multiple folders with a single PowerQuery script Read More »

Dynamically expand table or record columns in Power Query

In this article, we will show how to solve a common problem of expanding nested tables or records in Power Query, when the column names of the nested objects vary in numbers. In the second part of the article, we will show a more robust technique for dealing with changing structures of the nested tables. …

Dynamically expand table or record columns in Power Query Read More »

List.Generate() and Looping in PowerQuery

In this blog, we will explain an advanced topic about the M language – using List.Generate to loop over a table. We will combine our knowledge of lists, records, functions, iterations, and looping techniques. Basically, every important object in PowerQuery. Do-while Loop in PowerQuery Do while loop is commonly used in object programming. The idea …

List.Generate() and Looping in PowerQuery Read More »

Using M to dynamically change column names in PowerQuery

In this article, we are going to talk about cleaning and transforming column names dynamically and in a bulk. The article was inspired by a request from a client who had issues exporting data from its data warehousing program to .csv files. Out of an unknown reason, program was adding random spaces and non-printable characters …

Using M to dynamically change column names in PowerQuery Read More »

EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard]

The Internet is full of valuable online free sources which, if used correctly, can bring great incremental value to company employees. One of those sources is Eurostat, the statistical office of the European Union. On the official pages of Eurostat, you are able to pull pretty much any statistical data about the Macroeconomic environment of …

EU Countries Inflation rates since 2005 [PowerBI interactive Dashboard] Read More »

Scroll to Top