• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Turn insight into action using Microsoft Flow and Power BI

November 27, 2016   Self-Service BI

Today, I am happy to announce availability of the Power BI data alert connector for Microsoft Flow. By combining the power of Power BI data alerts with the hundreds of actions available for Flow, we’re making it easier than ever to go from insight to deep, meaningful action.

Microsoft Flow is a SaaS offering for automating workflows across the growing number of applications and services that business users rely on. You can set up Flows to take care of the important, repeating tasks that take place daily in your organization. For example, you can create a Flow to text you via SMS when your manager sends you an e-mail marked as  “high importance.” Or, automatically create a to-do item in Wunderlist when a customer e-mails your support line.

Data alerts are a recently released Power BI feature, which allow you to be notified whenever a tile on your dashboard meets a particular criteria. For example, you can set up an alert to send a push notification whenever tile “Daily Deliveries” > 10000. With this release, we are adding the Power BI data alert connector to Flow. This means that from a Power BI data alert, you can now trigger actions in dozens of other popular apps and services. Send an e-mail to a Security Group with the value of the alert. Post to a Slack channel with a link to the tile. Create a card in Trello based on the alert name. The list of possibilities is expansive, and it’s only getting bigger – new connectors are being added to Flow every week.

Get Started with Power BI and Flow

Ready to get started? What follows is a tutorial walkthrough for setting up your first flow. In this basic example, we’ll send out an e-mail to a broad audience whenever a Power BI data alert is triggered. You could imagine using a similar Flow to notify your support team whenever incident volume spikes.

Firstly, go to Power BI and set up a data alert if you haven’t already. If you need help, you can find the documentation for that process here.

With the alert set up, go to Flow, and sign in with your Work or school account.

Once you’re signed in, go to “My Flows” in the top left, and create a blank Flow by clicking on “Create from blank.”

4ab88890 2de1 4116 815f f7091dc7d73e Turn insight into action using Microsoft Flow and Power BI

7cd924f1 c90c 4dc9 9605 c6bf1717cf95 Turn insight into action using Microsoft Flow and Power BI

The first thing you’ll want to do is create a trigger, which is an event which sets the Flow in motion. Search “Power BI” in the box titled “Search for more triggers”, and select the Power BI data alert option which shows up in the dropdown.

96bf1c59 d8c0 4c8f 8d9f 697771bb9310 Turn insight into action using Microsoft Flow and Power BI

Next, select the name of the alert that you’d like to use to trigger the Flow.

d96e17c9 771f 4796 9be0 5ae941342951 Turn insight into action using Microsoft Flow and Power BI

Now, you’ll want to add an action to be performed when the Flow is triggered. In this case, we’ll add an action to send an e-mail. Click the “+ New step” box below the Power BI trigger to start creating a new option. In the search box, type “Outlook” choose the Outlook “Send an email” action.

Note: this tutorial assumes that you have an Exchange Online mailbox. If not, you can also try using the SMTP action, which allows you to send e-mail to any SMTP server.

Now, you can populate the fields of the box as you would with any email. Keep in mind that the mail will be sent from your account.

Also, notice that when you click into any field in the e-mail action, a box appears on the right, which allows you to add information from the data alert to the e-mail. For the Power BI data alert trigger, this information includes:

  • alertTitle: the name of the Power BI data alert
  • alertThreshold: the threshold at which the alert is triggered
  • isAlertTriggered: whether or not the alert was triggered – notice that this will always be True if the Power BI data alert is your trigger
  • tileURL: the URL to the tile on which the alert was set up
  • tileValue: the value of the tile at the time when the alert was triggered

47cb8158 f1f6 47d5 8af6 d2ea6d224979 Turn insight into action using Microsoft Flow and Power BI

Once you are satisfied with your e-mail, select Create Flow in the top bar to create your Flow, and you’re done!

5c36e038 3b6d 4376 beb6 85e3ed3d5a1d Turn insight into action using Microsoft Flow and Power BI

The next time this data alert is triggered, the Flow you just configured will activate, sending the e-mail that you configured to your target audience.

What’s next?

For more ideas on Flows, check out the Flow templates page to see a gallery of the most popular ideas. We’ve also added several Flow templates with the Power BI connector, including the one featured in the tutorial above.

Also, stay tuned to the Power BI blog, as we’ll be releasing something new Flow connectors in the weeks to come.

Have an idea for another way that Power BI can connect to Flow? Head to the Power BI UserVoice and cast your vote to make your voice heard.

Made a cool Flow? Share it with the community! Either post in the comments below, or in the Power BI forums. Who knows, your Flow might even be featured in the next Power BI Flow blog post!

Documentation links

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Action, Flow, Insight, into, Microsoft, Power, turn, using
  • Recent Posts

    • Accelerate Your Data Strategies and Investments to Stay Competitive in the Banking Sector
    • SQL Server Security – Fixed server and database roles
    • Teradata Named a Leader in Cloud Data Warehouse Evaluation by Independent Research Firm
    • Derivative of a norm
    • TODAY’S OPEN THREAD
  • Categories

  • Archives

    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited