25th October 2019 PowerApps – SVG Introduction In this SVG Introduction post we will cover adding a simple SVG drawing to a PowerApp screen. Future posts will show how to manipulate that image. Categories PowerApps/SVG
6th October 2019 Power Query Functions – SQL Procedures 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 Power BI/M/Power Query
5th October 2019 Power Query Functions – 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 Power BI/M/Power Query
29th September 2019 Power Query – Multi-step Function This post describes how to build a multiple step function in M using a parameter and using create function to build the function code. Categories Power BI/M/Power Query
27th September 2019 Power Query – Custom Handwritten Function In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries. Categories Power BI/Intermediate/M/Power Query
23rd September 2019 Power Query in Flow – Summarising the Data In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query. Categories Flow/Power Query
9th September 2019 AI Builder Object Detect Model with Power Automate and Power Apps 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. Categories AI Builder/Flow/How to/PowerApps
6th September 2019 Joining Tables of Data in Flow’s Power Query In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query. Categories Flow/Power Query
26th August 2019 Power Query in Microsoft Flow – An Introduction 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. Categories Flow/Power Query
13th August 2019 SVG in Power BI Part 7 – Using a Theme File to add SVG Icons 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. Categories Power BI/SVG/Updates
