Forum Discussion
Power BI real-time dashboard tiles - Historic Data
After support I've found the issue:
Looks like I pushed extra column data that is not specified in the Power BI Streaming Data.
eg.,
[{"device_type":"thermoMeter","DataTimestamp":"9/12/2016 5:14:42 PM","mac_address":"Thermal_Simulator","Temperature":200,"Humidity":446}]
"device_type" isn't on my Streaming Data table since I didn't need it in the Power BI side.
This will give an error when Power BI inserts the row.
Either add the column to the table or remove device_type value to fix this.
Thanks for great support :)
-Helen
- A while back, you created a streaming dataset via API option, and enabled historic analysis
Yes
- You've been sending data to this streaming dataset over the past few weeks
I've been sending data on and off but not continuously
- Today, when you push data, the visuals on your dashboard do update
Yes
- However, when you go to build a report, you don't see any data since 8/23
Yes
After support I've found the issue:
Looks like I pushed extra column data that is not specified in the Power BI Streaming Data.
eg.,
[{"device_type":"thermoMeter","DataTimestamp":"9/12/2016 5:14:42 PM","mac_address":"Thermal_Simulator","Temperature":200,"Humidity":446}]
"device_type" isn't on my Streaming Data table since I didn't need it in the Power BI side.
This will give an error when Power BI inserts the row.
Either add the column to the table or remove device_type value to fix this.
Thanks for great support :)
-Helen