Unit testing in Power Query M Language

As your code base gets bigger, test automation becomes more and more important. This applies to any development platform, including Power Query / PowerBI. If you reuse your code and improve some low level function later, test automation allows...

Getting started with LibPQ

This is a step by step guide to getting started with LibPQ, an illustrated version of "Installation and usage" section of the official documentation. Installation LibPQ source code The source code of the library has to be present in each workbook...

Loops in Power Query M language

Power Query Formula Language (also known as M language) is sometimes difficult to get your head around. This article explains how someone familiar with loops in other programming languages can approach the same concept in M language. First of all...