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:


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


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:


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


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.


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


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



Using the Microsoft Cognitive Services with Microsoft Flow and SharePoint Online Lists

Using the Microsoft Cognitive Services with Microsoft Flow and SharePoint Online Lists

This week I am attending the MVP summit in Redmond. This morning I had a chat with SharePointAppie about the possibilities of Microsoft Flow and the Cognitive Services. We had the following scenario: We want to get the hashtag of Twitter: #MVPSummit and put that in a SharePoint Online list. We want to see if the tweet about the MVPSummit is possitive of negative and write that score back to the SharePoint list.

Global solution:

  • Get items from twitter with Microsoft Flow
  • Save them in a SharePoint List a SharePoint List
  • Create a flow that sees new listitems in that list
  • Post it to Microsoft Cognitive Service Text Analyses / Sentiment via HTTP
  • The sentiment services gives a score 0 (negative) and 1 (positive)
  • Update the item with the sentiment score

It straight forwards, but when we came to the posting and getting information from the Cognitive Services with Microsoft Flow we had some issues.

Here some issues we had:

First of all: Posting to the service. We need authentication before we can post the tweet. Below the settings of the HTTP post. Just update your Subscription key and you can connect



The second part was more ‘complex’ and we did a lot of testing/debugging, the solution of course was simple….

We need to get the score out of the answer, in stead of storing the whole document. After a lot of testing we created the following settings in Microsoft Flow:


After putting the above into Microsoft Flow property, Flow updates the ‘code’ to the following (last item):


After that we now get the score of a tweetthe cognitive services directly back into a SharePoint list. There is one catch, you need to add a space before the “documents.score” element in the above screenshot, else I will not work…

Below the scores in the list, close to 1 the tweet is positive:



SmartBuildings factsheet

SmartBuildings factsheet

The last few months I wss busy with a SmartBuilding solution for some of our education clients to save square meters and give an app to studenten to find free rooms. Later I will create several post about the technical solution, but I have created (sorry its in dutch) white paper about this topic.

You can download it here from our website

Update for Microsoft Power BI on the iPhone

Update for Microsoft Power BI on the iPhone

I just received again an update for the Power BI on my iPhone. The following has changed:

  • I have huge problems with logging into Power BI with Azure AD. This is now solved
  • Preview: view and interact with optimized Power BI reports for the iPhone
  • Updated action bar for dashboards and tiles in focus mode
  • Finally 🙂 Breadcrumb navigation in tiles in focus mode

September update for Microsoft Power BI

September update for Microsoft Power BI

Microsoft just updated a news version for Microsoft Power BI with the following update:

Report View
ArcGIS Maps for Power BI (Preview)
Mobile report layout (Preview)
Updated drill behavior

Forecasting (Preview)
Use your own R IDE

Data Connectors
Snowflake Connector DirectQuery Support
ProjectPlace Connector
Oracle Connector – Improved Navigator Previews Performance
OData Connector – Support for “Select Related Tables” option
SAP BW and SAP HANA Connectors – Enhancements to parameter input UX
Web Connector – UX Support for specifying HTTP Request Headers

Query Editing
Query Dependencies view
Show Errors experience
Query Editor Ribbon Support for Scalar Values
Add Function Invocation Column
Expand & Aggregate Columns – Support for “Load More” values
New Transform – Convert Table Column to a List
Keyboarding – Support for “smart typing” in dropdown menus

Here a video about the news features: