Power Automate get data from Power BI dataset

Power BI datasets contain a brilliant source of data that would be useful in a Power Automate flow. In this video we do a simple example of pulling sales results from a Power BI dataset and emailing it to a manager.

Blog post to support video
https://hatfullofdata.blog/power-auto...

Report and data used in this video can be found here
https://github.com/Laura-GB/DemoData#...

Table of Contents
00:00 Introduction
00:12 Look at Report
00:33 Create Flow
01:49 Create Query text in PBI Desktop
03:35 Use Performance Analyser
04:20 Put Query text into Power Automate
04:41 Add Create HTML Table step
05:04 Add Send Email step
05:50 Test the Flow