Laura Graham-Brown

Information & Communications Technology

Microsoft Flow Powerapps power bi Citizen Development Office 365 Microsoft MVP #PowerPlatform Microsoft Power Apps Microsoft Power Automate Power Query Power BI Dataflows Microsoft Power BI Microsoft Power platform Microsoft Business Intelligence

Hemel Hempstead, England, United Kingdom

Laura Graham-Brown

MVP, Power Platform Consultant and Agony Aunt

Business Applications Microsoft MVP working as a Solution Specialist for HSO
Over 20 year experience at being passionate about training, solving problems and loving a new challenge. Worked with a wide variety of clients both corporate and public services, enabling their citizen developers to create solutions to improve business processes.
Organiser of London Power Platform user groups

Current sessions

Dataverse and Power BI

Power BI is part of the Power Platform family. Microsoft have the slide with all the members of the family in a row above data sources and Dataverse is there as the recommended data source for the Power Platform projects.

So what does connecting to Dataverse from Power BI look like? This session will look at the good, the and the ugly parts of connecting to Dataverse. As much as we all embrace the low-code revolution it can create some interesting data models.

I promise a demo rich session.


Intro to writing Power Query functions in M

The transformation of data in the Power Query stage of Power BI reporting is a very important stage and often scary to the newbie to edit any of the code, let alone write functions. This session will start with the "hello world" function and working up to more complex functions to use in your queries. Using parameters to make reusable building blocks to use again and again. No programming experience required although caffeine might be recommended.


Create your first Paginated Report

10 minutes from no report to a published report ready to rock and roll.


Brilliant Power BI Report. Can I print it?

You spend hours working on visuals including slicers and filters to give your management a fully dynamic report to answer their every question, and your heart sinks as they ask how to print it. As much as it is tempting to just reply “No!”, we need to move people to Power BI in baby steps so we need a printing solution.

In this session we will walk through the possibilities of using the new Power Automate actions to deliver a reports in printable formats. With the recent announcement at Microsoft Ignite of premium per user, paginated reports are now a real possibility for more companies. We will also look at the mechanics of building a paginated report based off your Power BI desktop report.


Introduction to Paginated Reports

Paginated reports allow for that pixel perfect report to be built that can span multiple pages, delivered via email or combined with Power Automate to be saved in a team. It is not a replacement for Power BI but a complimenting service when you need that snap shot report. Now that Premium features are more available through Premium per User licences, paginated reports are a good solution for more companies.

In this session we will start with the basics, assuming no prior knowledge and cover the following topics.

Connecting to data and creating datasets.
Creating a tabular report and adding parameters
Publishing and Subscribing to a report
Creating a template
Connecting to a Power BI dataset.
Visuals and Conditional Formatting

Recommended 60+ minutes for this session.
https://www.youtube.com/playlist?list=PLclDw3xU_tI5bypr74FnLuLGTyuTfKpV1 for a taster of the session


Power BI and SVG

Power BI reports work because they are visual, they can include many different ways to visualise your data. Scalable vector graphics (SVG) define shapes including size, colour and opacity using an XML based format. This session will show how you can use SVG to add unique visuals to your reports that will change with the data without too much coding. The internet is full of svg icons so the possibilities are endless.


Intro to writing Power Query functions in M

The transformation of data in the Power Query stage of Power BI reporting is a very important stage and often scary to the newcomers to edit any of the code, let alone write functions. Learning how to tweak the M and write a few functions will open up huge possibilities to modernise and replace those complex Excel reports written in VBA.
This session will start with the "hello world" function and working up to more complex functions to use in your queries. Using parameters to make reusable building blocks to use again and again. No programming experience required although a shot of caffeine might be recommended.


Power Query is taking over

An ever-popular tool for data analysts, Power Query first made an appearance in Excel and quickly became the engine behind PowerBI. More recently it has appeared in Power Automate as an extension the SQL connector and a tool for CDS. Providing the ability to transform data on the fly, understanding Power Query and the Language M is now an important skill for the keen citizen developer.

In this session we will look at how to transform data ready for your PowerApp or Flow and how to get Power Query to work it’s magic without having to write complex queries in M. For those that do want to push the boundaries further, we’ll look at the options for diving into the M code itself for more powerful options.


Past and future events

Power BI Summit 2022

6 Mar - 10 Mar 2022

Scottish Summit 2022

25 Feb - 26 Feb 2022
Glasgow, Scotland, United Kingdom

Power BI Fest

19 Nov 2021

#DataWeekender v4.2

5 Nov 2021

Scottish Summit

29 Feb 2020
Glasgow, Scotland, United Kingdom

Office365 & SharePoint Connect Community Edition

9 Oct - 10 Oct 2019
Haarlem, North Holland, Netherlands

Data Relay 2019

7 Oct - 11 Oct 2019

Power Platform World Tour London

Session - Power Query and Flow
In September 2018 Microsoft introduced the Power Query Online integration for Microsoft Flow. This opens up the possibility of transforming and shaping data within Flow without having to understand OData or SQL.
This session will demonstrate different ways of combining data, transforming data, and then exposing the data as a csv, html table or looping through the records to automate a process based on your data within SQL server.
Finally we will look at the costs, limitations and considerations when using this new feature and the licenses that you require to use these techniques.
28 Aug - 29 Aug 2019
London, England, United Kingdom

Collab365 Flow Virtual Summit

Online summit dedicated to Microsoft Flow
Session - Task Management using Flow
This session covers accessing tasks in lots of different platforms from Planner, to Wunderlist to Project Online.
It covers the challenges of different formats, triggers and copying complete lists from one platform to another to help you manage lists.
10 Jul - 11 Jul 2019

Power BI Days Belgium 2019-06

21 Jun 2019
Kontich, Flanders, Belgium

Power BI Days Belgium 2019-04

12 Apr 2019
Mechelen, Flanders, Belgium

PowerApps Virtual Conference

In this session, we will build a Hangman game that selects a word and lets the user pick letters and for every wrong answer draws another part of the hangman. Many "learn to code" courses include programming a game to explore different techniques in a fun way. The methods included here include using collections to track activity, using galleries to display a keyboard and correctly selected letters, using SVG to draw the hangman and using a timer to make a loop to set it all up.
27 Mar 2019

SharePoint Saturday Leicester

Power BI Introduction - So just how hot was this summer?
Level: 100
Track: End-User, Business
Power BI is a great tool from Microsoft to collect, transform and visualise your data in dynamic reports. It can handle a wide variety of data formats. Weather stations across Europe collect lots of data every day of every year.

This session is designed for anyone with little or no experience in Power BI. If you would like to learn about transforming data using queries, relationships, pretty visualisations, slicers and some natural language questions then this session is for you. Come and find out just how hot this summer has been compared to previous years.
10 Nov 2018
Leicester, England, United Kingdom

SharePoint Saturday Belgium 2018

19 Oct 2018
Brussels, Brussels Capital, Belgium

SharePoint Saturday Cambridge UK

22 Jun - 24 Jun 2018
Cambridge, England, United Kingdom