Embed a Table from Power BI in an Email with Power Automate

Power Automate can query your Power BI datasets. If you're unsure how to write the query, here's a trick to pull the DAX directly from a visual in your report to use in the "Query a Power BI Dataset" step.

You can draw your recipients list directly from your data or from another source, then filter it however you need in Power Automate before adding it to the email. Embed as an HTML table or attach as CSV - or both!

For those asking how to format the columns in the table, you can either use DAX FORMAT() in Power BI or use the technique you see Reza using here with "format by example" on the columns on the Power Automate side. He also mentions how to style the table in a super-friendly way right after formatting!:    • ChatGPT and Power Platform | How to u...  


0:00 Intro
2:40 Getting the query
3:25 Creating the flow
5:20 Entering the query
6:30 Parse JSON - getting the schema
7:21 Getting distinct email addresses from our data
10:43 Filtering our data for each recipient
12:21 Creating the HTML table and CSV
14:20 Creating the email
16:50 Testing the email