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:
• Use the Power Automate visual in Powe...
The PBIX used in this video is available here:
https://github.com/chpayton/BIFiles/...
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