Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |