Sign in

Lucky you if you work for a company which has just one tenant. Then, if you have a storage account with an activated firewall, you can connect to it from all ADFs, Synapse Analytics Workspaces, and so on across subscriptions with ease. Everything works together like a charm. But it…


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…

Nolock

Cloud BI Professional Architect

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store