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…

With all the craziness in our lives due to coronavirus, the reliance today on facts is more important than ever. To help you stay safe I thought you would appreciate this tutorial to learn how you can build your own reliable Power BI report that can analyze the confirmed infections, recovery and death rates of …

Grouping Basics You can find the Group By button on the Power BI Query Editor window in 2 places: In the result dialog box, you can choose your key columns and aggregates. The key columns will default to what columns you currently have selected: From here, you will get the grouped result: Custom...

This article discusses how to scrape data from dynamic websites that reveal tabulated data through a JavaScript instance.

Sometimes, you need to create a multiplication of all sets of all pairs from two different data tables in Power BI. This action is different from Merge (Join) because there is no matching key columns and no way to relate the two tables together. However, you want to create a multiplication as a flatten table.…

The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can…