Send STYLED Lists or Tables from Power BI to EMAIL or Chat with Power Automate

This is a tutorial on how to use the “Run a query against a Power BI dataset” action in Power Automate to send formatted, styled data to users via email or Teams chat message. This can be row data, aggregate data, your measures with or without conditional formatting, whatever you like. You can send the messages to assignees, owners, or any other user attached to your data rows (assuming you have their email addresses). The gist of it is we concatenate HTML tags containing CSS styles with our data, pass it to Power Automate, and insert it in email/Teams chat. This demo shows a bulleted list and a table, but you could do other crazy things here too. This video sends data on a schedule, but you might also be interested in the Power Automate visual button that we use to send notifications for selected table rows here: https://youtu.be/8p2uXihLWrs The PBIX used in this video is available here: https://github.com/chpayton/BI-Files/blob/main/Misc/Planner%20Data%20Demo%20-%20Power%20Automate%20HTML%20(github).pbix 0:00 Intro/what it looks like 2:15 Create the item hyperlinks (if using) 5:33 Collect what you want to send in a table visual 6:30 Bulleted list DAX 11:45 Create the flow 13:23 Copy the DAX query from the table 15:40 Parse the JSON & loop over results 17:38 Put data in Teams message 19:16 Put data in email 20:55 Styled tables 27:46 Add aggregate measures 29:05 Update the flow