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

Report and data used in this video can be found here

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

[silyryr]

I came on line to find this EXACT requirement, and find it from the woman that taught me power bi. I'd call that a successful day Mrs GB

[urbatin]

I struggled for a week trying to get 1 flow to work and less than 5 minutes into a video you made this so easy. THANK YOU!

[johntwohig]

Thank You! That opens up so many possibilities that wouldn't be possible trying to connect to the data in Power Automate.

[Bananakillaaa]

I have been struggly hard to get the DAX query. Your video has been life-saving! Thx

[AnhNgoc-tryp]

Thank you very much. This video is really simple and easy to understand

[vkings]

Excellent tutorial, the query part is really hidden so thanks for clearing it up

[berggrog]

Nice work. Simple video that shows a simple solution nicely explained.

Thank you!

[BadHoneyBadger]

You are my new best friend. First excellent explanation of this process I have found. Thank you so much.

[TejinderSingh-eswh]

Thanks, This is the only way I found to solve my problem of PowerBi limiting only one data alert per hour.

[dannyec]

Thanks for your sharing. I am struggling on the DAX query and the video is really helpful for me.

[zerobars]

Great Tutorial, well explained. Thanks

[MilhouseBS]

thanks, and you can test RLS for the query also. Nice demo.

[kkqmvfi]

Thank you for this video, it's life saving

[nataschalaros]

Thanks! Is it also possible to further specify the email list based on the dataset in the report? Eg. dataset Data Quality + related buyers: send only data of each specific buyer to related buyer email?

[SoumenGhoshal]

These steps are not working. Running a query using power bi dataset results in an empty table and further steps don't execute.

[jhonmedinahuanacomedina]

Hola, no viene al tema del video pero, como puedo cambiar el interfaza de panel de informe, veo el area de trabajo es amplia y los iconos son pequeños. Gracias

[SS-lvpn]

I was wondering if below scenario is possible with power Automate or not ??
Let's say if we want cross report slicer sync in power bi , this feature is currently not available in PBI, is it achievable using Power Automate

[yadukrishnankv]

Thank you for the video @Hat Full of Data!

Would I be able to query each column separately using this method and paste into a SharePoint list?

Thank you!

[ritamgiri]

So, I came across a requirement to establish that I have to do the same thing except sending the data into a mail, I have to to add a new row to a dataverse table. Do you think is it doable?

[razibhasan]

Hi Laura! Firstly, thank you so much for this awesome video. It explained the whole concept in a very lucid manner. Really appreciate it.
Now, I have a question. Say, I want to automate the whole process for different filters (-30 to 30) and save those tables according to the applied filter names. How should I approach?
Thanks in advance.