When I was developing a new dataset, which was going to be referenced by many hundreds of reports, I wanted to be able to tell the end users that this dataset is under maintenance for some time. …

In this short blog post, we will learn how to create a separate table for measures which are developed by citizen developers when creating a new report. …

A year ago, I was developing a solution for collecting and analyzing usage data of a Power BI premium capacity. There were not only some simple log files, but also data that I had to convert into a slowly changing dimension type 2. Therefore, I decided for the following architecture…

Today I will deep dive into an elementary feature called Clipboard. You use it probably hundred times a day using the keyboard shortcut Ctrl+C and Ctrl+V. But do you know what happens behind the curtains in the Power Query Editor when you copy a query? What is a clipboard in the computer science terminology? Let´s ask Wikipedia. It says…

I have prepared an article about a transitive closure in Power Query. I wanted to publish the article already, but I decided to wait a little bit and write another one about a performance boost I’ve used in the code. It is a lookup table in Power Query. Imagine the…

I’ve been testing incremental refresh for more than half a year in an enterprise environment and I’d like to share my experience with this feature. You can read a full description of Power BI incremental refresh here. …

One of the many benefits of Power BI is the possibility to create your own theme file, which defines many design properties of a report, like colors, fonts, and many more. There are also tools on the internet that help you to create such a theme file. But, as you…

Recently, I have been faced with a challenge of pivoting many tables. Every table was completely different, I needed some preprocessing steps, like filtering rows and so on. And I also didn’t want to pivot a huge table in Power Query. The solution? …

Is there a simple way to convert a timestamp in UTC to your local time zone in Power Query? Yes and no. Let’s find out what the options are. TLDR section https://github.com/nolockcz/PowerQuery/tree/master/UTC%20to%20Local%20Time However, I personally recommend reading the article once before you use it in your project. Research I have started with research…