DirectQuery and 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-sihou-msft]

@prateekraina

Since Direct Query is not supported for Documentdb yet, I think using Stream Analytics to send data from IOT Hub to Power BI could be a better option currently. Please submit a feature request on idea.

Regards,

[prateekraina]

Hi @v-sihou-msft,

But there is no support for filtering if i go the way you suggested right?

[v-sihou-msft]

@prateekraina

It's true. Currently we can't filter dashboard, we can only pin entire live page to achieve similar goal. However, it's not for streaming data scenario.

Regards,