Power Query

Create variable columns while using Split by feature in Power Query. Create Dynamic Columns while using Split by in Power Query

Format your PowerQuery (M-Language) code with Power Query Formatter

You have lost your column types in Power Query and want to get them back? Check how easy it is to automatically detect and change all column types at once.

Currently I am working with a project where we extract data from a SQL server – some of the business logic is built into scalar value functions (documentation). Now the magic of PowerQuery enables …

Have you ever wished you could change multiple Power Query load destinations at once? Well now you can with Monkey Tools!

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

Recursive functions in Power Query are not very popular, but sometimes very helpful when in need. In this post, I'll explain what a recursive function is, how it works, and explain it through a famous recursive example of Fibonacci Sequence. Fibonacci Sequence Fibonacci sequence is one of the fundamental recursive operations in math, below are…

Dynamically retaining only columns that contain Actual values from a Table This article is part 3 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain […]

When you have a tool that can carry out up to 380 data transformations, mostly through simple GUI clicks, then the tool is not ordinary. That explains why Power Query, originally born in Excel, is now a powerful engine in many other tools (Power BI, Power Automate, CDS, Azure Analysis Services, ma...

We’re pleased to announce the first Monkey Tools update is now available! A new feature, some new logic and an update to our Power BI connector.

Utilizing Power Query Lists 2/3 This article is part 2 of the Using Power Query lists series. In this series, we will look at how we can use lists to do the following: Dynamic Filtering on a Column Using Lists Changing a Table of Attributes and Values to retain only Top 10 Attributes (by values) […]

This is a documentation of hidden but essential microsoft power query keyboard shortcuts, for power bi, that is meant to make operations less tedious.

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table It can occur with almos…

Want to download files from webpages with Power Query to regularly refresh in Power BI? See how to find their URL and tweak their parameters to your needs:

I have a Power Query script that I usually use in any Power BI solution that needs time-based analysis. However, I never had a chance to publish it here for everyone to use. So here it is. A friend's question about a time table reminded me that it is good to publish this to the…

This blog post shows how you can safely transform column types in Power Query, accounting for columns that can possibly be missing.

Monkey Tools is an Excel add-in that provides tools that help you build better Excel based models more quickly, and audit those you receive from others.

MonkeyTools Pro is a set of tools to help you build better data models more quickly and using data modelling best practices. They also help you audit what has been done in your data model.

A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7? If so, their reports are likely to be slo…

For a solution I’m currently working on, I needed to get a list of all the tables of my solution with some information (name, position and type) of their respective columns. The goal was to e…

In a recent project, I was facing a really weird JSON structure. Each element of the JSON was more or less a dictionary with sparse keys. It means that the field names were different from an elemen…

I’m currently working on the setup of a data quality dashboard and Power BI was our natural choice to display valuable information. For an advanced use-case, we needed to consume CSV files co…

This blog post is the second of a series related to parsing time series about COVID-19, you can find the first one here. When dealing with time series, you should always check if your time series a…

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what…