Author: Laura GB

Over 20 year experience at being passionate about training, solving problems and loving a new challenge especially in the Microsoft's Power Platform suite.

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.

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.

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.

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.

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.

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.

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.

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.

Power BI/SVG/Updates

7th August 2019

Power Automate – Creating Adaptive Cards

This post is to support a video posted on YouTube regarding creating an adaptive card for Microsoft Teams using Microsoft Flow.

How to/Flow/Introduction

6th August 2019

SVG in Power BI Part 6 – New Icon Conditional Formatting

In July 2019 Power BI Desktop update they included new conditional formatting on table and matrix to include icons. These icons can be defined using SVG which is pretty cool. So this is a new post in my Power BI SVG series looking how we can use SVG icons in conditional formatting.

Power BI/SVG/Updates