Smartdata flow with IoT Hub, Stream Analytics, Power BI data alerts and Microsoft Flow

Smartdata flow with IoT Hub, Stream Analytics, Power BI data alerts and Microsoft Flow

Several weeks a go a new function was released in Power BI, called Data Alerts. With Data Alerts you can create alerts on data in your Power BI Report. That data can off course flow from the Microsoft IoT Hub with Stream Analytics.  I will give you an example of a scenario. In the following report I count the amount of messages we receive from the Microsoft IoT Hub at a client. If the amount will exceed more than the threshold of 2300 I will need to receive an e-mail. And there comes Microsoft Flow.schermafbeelding-2016-12-07-om-11-40-38

 

 

 

 

 

 

 

 

If you click on the three points on the top right of the card in Power BI, you now will get some options:

schermafbeelding-2016-12-07-om-11-22-41

Now you see a alert button in the middle. When you click on the alert button you will get a new screen:

schermafbeelding-2016-12-07-om-11-23-06

In this screen you can manage the new alert. I have set a threshold above 2300 to get an alert. Hit ‘Save and Close’ and the alert is saved.

Now begins the cool stuff, Microsoft Flow added support for Power BI Alerts since three weeks. When you navigate to Microsoft Flow you can create a new Flow and search for Power BI:

schermafbeelding-2016-12-07-om-10-06-44

Click on Power BI – When a data driven alerts is triggered and you see your alerts and the alert we just made:

schermafbeelding-2016-12-07-om-11-25-33

Then you can create an action when the threshold is above the number 2300. And there comes the power of Flow.  In this example I will receive an e-mail, but off course you can also update Microsoft CRM or other (MS) services in Microsoft Flow. See here or a complet list.

schermafbeelding-2016-12-07-om-11-26-40

Hit the save button and wait for the mail 🙂 Below the mail I received when the threshold was above 2300:

schermafbeelding-2016-12-07-om-11-26-59

I really like this new functionality. Now you can easy create (data)flows with IoT solutions without the need of any programming!

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s