After 6 months there has been a lot of changes in the offering of Azure and Power BI. Those changes implies that my blogposts about connection Stream Analytics and Power BI (1, 2 and 3) are not completely the best and easiest way of doing this.

Power BI changes

It is still in preview, but Stream Analytics supports directly out of the box a connection to Power BI as an output. Stream Analytics only needs a valid authentication and a dataset name and a table name. If the dataset and/or table doesn’t exist, it will be created.

image

So in my case I don’t need a custom application anymore to pull the events from Stream Analytics and push them to Power BI.

Stream Analytics changes

Starting today, September 29th 2015, Microsoft has announced the Azure IoT Suite: http://blogs.microsoft.com/iot/2015/09/29/azure-iot-suite-now-available/. Within this suite there is now a dedicated event Hub for IoT devices. And within Stream Analytics it is possible to use this new IoT hub as input.

image

Interacting with this hub is easy and especially made for IoT devices, so a low level easy to use. See https://azure.microsoft.com/en-us/documentation/articles/iot-hub-csharp-csharp-getstarted/ for more information on how to use it.

With all this changes I write a new blogpost on how to do it this weekend (no promises made)

-JP

© 2022 Azure BI (Jan Pieter Posthuma)
Lovingly made in 
Lovingly made in 'de Achterhoek'