DirectQuery in DocumentDB

[prateekraina]

HI Everyone,

Can anyone suggest what is the best possible way to integrate IOT solution with Power BI.
I have alreday considered below options:

1. Using Stream Analytics to send data from IOT Hub to Power BI. I cannot use this approach because i have data coming in from thousand sensors and since filtering is not allowed on dashboard so dropped this option.

2. Using DocumentDB to store timeseries data and then creating reports on top of it. I had to drop this approach as well becaise DirectQuery is not supported in DocumentDB yet and i cannot afford to wait for 1 hour to get my dataset refreshed.

Please suggest some approaches.

Prateek Raina

[v-ljerr-msft]

Hi @prateekraina,

---

---

1. Using Stream Analytics to send data from IOT Hub to Power BI. I cannot use this approach because i have data coming in from thousand sensors and since filtering is not allowed on dashboard so dropped this option.

According to the following articles, we can also create reports(not only dashboard) to visualize real-time sensor data from Azure IoT Hub using Power BI. Could you go to check if that is the case? 

https://docs.microsoft.com/en-us/azure/iot-hub/iot-hub-live-data-visualization-in-power-bi

https://blogs.msdn.microsoft.com/uk_faculty_connection/2016/03/20/consuming-data-on-microsoft-azure-...

Regards