Category: Power Query

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

15th April 2020

Power Query – Replace values for whole table

Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them.

Categories M/Power BI/Power Query

6th October 2019

Power Query – Function to Execute an SQL Procedure

This is the fourth post in my series regarding writing custom functions in Power Query. This post describes how to create a function that will execute an SQL procedure, passing in a parameter. Stored Procedure My database contains a very simple procedure that given a cost center returns all the expense records. It can be run with the following SQL...

Categories M/Power BI/Power Query

5th October 2019

Power Query – Building functions to fetch web data

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

Categories M/Power BI/Power Query