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.
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.
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.
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.
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)