Category: Power Query

13th January 2025

Power Query – Handling Null Values

This post is about handling null values in Power Query calculations. If you do a calculation in Power Query that involves a null value the answer returned is null.

Categories Power Query Comments: 0

8th January 2025

Power Query – Fixing Missing Columns Dynamically

One of the challenges of making sure your query works in Power Query is data sources that have a changing schema. Some APIs miss out fields if the data is null and sometimes we need one report able to handle data files that are almost the same but not quite. In this post we will look at fixing 2 scenarios, a single missing column and multiple columns missing.

Categories M/Power Query Comments: 0

6th January 2025

Power Query – Creating New Parameter Made Easier

Good practice is to use parameters for these values so your query is reusable etc. And its always our intention to go and create the new parameter later.

Categories Excel/Power BI/Power Query Comments: 0

8th June 2021

Power Query – Get Previous Row Data

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person’s previous score.

Categories M/Power Query

4th May 2021

Power Query – Dynamic Data Source and Web.Contents()

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic Data Source. It will not refresh in the Power BI service unless you do some tricks. Fetching Data...

Categories M/Power BI/Power Query

21st April 2021

Excel Power Query – VBA to Edit a Parameter Value

This post is to document how to use Excel VBA to edit a parameter value without using the a cell reference in Power Query.

Categories Excel/Power Query/VBA

7th April 2021

Power BI Desktop Connecting to Dataverse

Dataverse is a secure flexible data storage solution that is part of the very popular Microsoft Power Platform family. So connecting to Dataverse is an obvious request. Dataverse was previously known as Common Data Service. This post is from getting very frustrated mid-hackathon and trying to connect to Dataverse and just getting an odd error. If you want to learn...

Categories Power BI/Power Query/Uncategorized

15th January 2021

Power Query – AI Insights Error

AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.

Categories Power BI/Power Query

15th November 2020

Power BI – Tea & Biscuits Session at London Reactor

This post is to support my virtual introduction to Power BI session for London Reactor on 16th November 2020.

Categories Power BI/Power Query

22nd August 2020

Power BI – Import text using examples

Import text using examples was introduced in the 2020 August update for Power BI. It writes the Power Query steps to transform a non-tabular text file into a table.

Categories Power BI/Power Query