-
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 you to make sure your changes did not break anything that depends … -
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 that uses it. Create a new blank query: Data … -
Expanding Power Query standard library - introducing LibPQ
Power Query formula language (also known as M language) is a very capable yet not very flexible tool. It lacks some features taken for granted by developers who are used to other programming languages such as compatibility with version control systems, extensibility by third-party libraries, etc. That is why I …