power query

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

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...

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 …

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…

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…

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…

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…

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…

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…

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.

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.

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

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…

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:

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…

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

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) […]

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.

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...

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 […]

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…

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.

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

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 …