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! ⏲️ TIMESTAMPS 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 ▶️ RELATED VIDEOS - Send STYLED emails from Power BI with Power Automate: https://youtu.be/8YnBotHynD0 - Send selective notifications with a button click in Power BI: https://youtu.be/8p2uXihLWrs - Power Automate playlist: https://www.youtube.com/playlist?list=PLVWnQj3YS9wuCbVH0Z9aWP451IFFH6xYd 🎓 COURSE - I’m working on a course! Join the waitlist here: https://bi-ome.kit.com/waitlist 🪽 CONNECT WITH ME - Subscribe via email: https://bi-ome.kit.com/youtube - Blog: https://christine-payton.com/ 📣 Get new videos via email! - https://bi-ome.kit.com/youtube #automation #emailautomation