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.
In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.
In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.
In this post I will document how to build an AI Builder object detect model. We will create the list of items to detect, upload images, identify each image and then train the model.
In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.
This is the first post in a new series regarding Power Query in Flow. In this post I will cover the basics of connecting to SQL Server, filtering and sorting the data and finally adding calculated columns.
As part of the July 2019 update there were changes to conditional formatting. In this post I am going to cover adding to or swapping the built in icons using a theme file and some SVG.
This post is to support a video posted on YouTube regarding creating an adaptive card for Microsoft Teams using Microsoft Flow.