Embed a Table from Power BI in an Email with Power Automate
Автор: Christine Payton
Загружено: 2023-06-12
Просмотров: 75809
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: • Send STYLED Lists or Tables from Power BI ...
Send selective notifications with a button click in Power BI: • Use the Power Automate visual in Power BI ...
Power Automate playlist: • 🪼Power Automate
🎓 COURSE
https://christine-payton.com/course/
🪽 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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
