Category: Power Query

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.

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

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.

This post describes how to build a multiple step function in M using a parameter and using create function to build the function code.