Microsoft Flow is a SaaS offering for automating workflows across the growing number of applications and SaaS services that business users rely on. With Flow you can automate tasks by integrating your favorite apps and services (including Power BI) to get notifications, synchronize files, collect data, and more. Repetitive tasks become easy with workflow automation.
Watch Sirui create a Flow that sends a detailed email to colleagues when a Power BI alert is triggered. Then follow the step-by-step instructions below the video to try it out yourself.
In this task we'll use a template to create a simple flow that is triggered by a Power BI data alert (notification).
Sign in to Microsoft Flow.
Select My flows.
Select Create from template.
Use the Search box to find Power BI templates and select Post a message to a Slack channel when a Power BI data alert is triggered.
Select Use this template.
If prompted, connect to Slack and Power BI by selecting Sign in and then following the prompts. A green checkmark lets you know that you're signed in. After you confirm your conections, select Continue.
This template has one trigger (Power BI data alert for new Olympic medals for Ireland) and one action (post a message to Slack). As you select a field, Flow displays dynamic content that you can include. In this example we'll included the tile value and the tile URL in the message body.
From the trigger dropdown, select a Power BI data alert. Select New medal for Ireland. To learn how to create an alert, see Data alerts in Power BI.
To post to Slack, enter a channel name and message text. Notice the dynamic content that we've included in the message text field.
Include "@" at the beginning of your channel name. For example, if the Slack channel is named "channelA", in Flow enter "@channelA".
When you're done, select Create flow. The flow is created and evaluated. Flow lets you know if it finds errors.
If errors are found, select Edit flow to fix them, otherwise, select Done to run the new flow.
Open your Slack account to see the message.
In this task we'll create a simple flow from scratch that is triggered by a Power BI data alert (notification).
Sign in to Microsoft Flow.
Select My flows > Create from scratch.
Use the Search box to find a Power BI trigger and select Power BI - When a data driven alert is triggered.
From the dropdown, select the name of your alert. To learn how to create an alert, see Data alerts in Power BI.
Select New step > Add an action.
Search for Outlook and select Create event.
Fill in the event fields. As you select a field, Flow displays dynamic content that you can include.
Selet Create flow when done. Flow saves and evaluates the flow. If there are no errors, select Done to run this flow. The new flow is added to your My flows page.
When the flow is triggered by your Power BI data alert, you'll receive an Outlook event notification similar to this one.