Forum Discussion

Prefsmaster's avatar
Prefsmaster
Regular Visitor
9 years ago
Solved

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...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Prefsmaster

    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's avatar
Prefsmaster
Regular Visitor
9 years ago

Eric_Zhang

 

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's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Prefsmaster

It is great to hear that your issue has gone. If no further questions, could you please close accept a solution to close this thread?

 

Meanwhile, to reduce confusion, I've already escalated this behavior to the Product team.