Forum Discussion
Prefsmaster
9 years agoRegular Visitor
Pushing data to PowerBI Streaming dataset API fails when historic data analysis is ON
The Topic says it all. I have successfully created an API and was happily pushing events to it. Then I created an Azure Webjob that pushes some random data every second or so. Data flows nicely an...
- 9 years ago
What is the JSON format in your case?
In my test, before enabling "HISTORIC" I can upload data with{ "DATETM" :"2017-03-02T09:04:48.837Z", "SALES" :5000000 }However after enabling "HISTORIC", I got a 400 error though the upload data would finally get saved as in your case. The reponse contains the the error saying something wrong with the dataset JSON. In case you have interest, the tool is POSTMAN.
Based on my test, with a dataset JSON format as below could always work either the "HISTORIC" is enabled or disabled.
[ { "DATETM" :"2017-03-02T10:04:48.837Z", "SALES" :45000000 } ]You can actually send multiple data in JSON array.
[ { "DATETM" :"2017-03-02T10:04:48.837Z", "SALES" :45000000 }, { "DATETM" :"2017-03-01T09:04:48.837Z", "SALES" :38000000 } ]
Prefsmaster
9 years agoRegular Visitor
That did the trick!
Thanks a lot. It would make more sense if the error also appears when HISTORIC is OFF though :-)
Or clearly explain in the documentation and examples what should be sent...
Eric_Zhang
9 years agoMicrosoft Employee