topic Re: Error streaming dataset flow with power BI in Developer

Error streaming dataset flow with power BI

tleamon — Mon, 28 May 2018 07:02:03 GMT

Hi Everyone,

I am trying out the real time streaming dataset but it doesnt seem to be working wrong. It appears that I am formatting the data wrong as it is returning:

{
    "error": {
        "code": "RealTime_PushRowsInvalidJson",
        "pbi.error": {
            "code": "RealTime_PushRowsInvalidJson",
            "parameters": {},
            "details": []
        }
    }
}

My data in powerbi dataset settings is:

[
{
"timestamp" :"AAAAA555555",
"temperature" :"AAAAA555555",
"humidity" :"2018-05-28T06:59:10.835Z"
}
]

And the data Im sending through a post is:

[ {`
“timestamp” : “2016-09-10T01:26:45.030Z”,
“temperature” : 98.6,
“humidity” : 98.6
} ]

Re: Error streaming dataset flow with power BI

v-jiascu-msft — Tue, 29 May 2018 05:23:03 GMT

Hi tleamon,

If you didn't input the wrong settings here, maybe you need to change the settings.

[
{
"timestamp" :"AAAAA555555",  <---should be date time
"temperature" :"AAAAA555555",
"humidity" :"2018-05-28T06:59:10.835Z"  <---should be number
}
]

I don't know which language you used. But the format seems wrong.

1. The parentheses.

2. The data should be in a Json format.

The below is how I did with Python.

push_url = "https://api.powerbi.com/***"
for item in data_to_push:  # the data you posted
    data = json.dumps(item)  
    r = requests.post(push_url, data = data)
    print(str(data) + " pushed.")
    print(r.status_code)
    time.sleep(1)

Best Regards,

Dale

Re: Error streaming dataset flow with power BI

tleamon — Wed, 30 May 2018 00:40:21 GMT

Hello v-jiascu-msft,

Thank you very much for the reply and I did not notice that I had a timestamp labeled as the wrong data type. Sadly this didnt fix my issue. I am actually just using Postman right now to send posts to the url. I have attatched a screenshot of the data I am trying to send as well as the way I have my realtime data item set up.

Re: Error streaming dataset flow with power BI

v-jiascu-msft — Wed, 30 May 2018 01:57:09 GMT

Hi tleamon,

The error message shows the data is a invalid json data. Please try these two format below.

{
"timestamp" : "2016-09-10T01:26:45.030Z",
"temperature" : 98.6,
"humidity" : 98.6
}

"{
"timestamp" : "2016-09-10T01:26:45.030Z",
"temperature" : 98.6,
"humidity" : 98.6
}"

Best Regards,

Dale

Re: Error streaming dataset flow with power BI

v-jiascu-msft — Wed, 30 May 2018 15:03:53 GMT

Hi tleamon,

Please refer to the snapshot below.

Best Regards,

Dale

Re: Error streaming dataset flow with power BI

tleamon — Wed, 30 May 2018 17:58:22 GMT

Thanks for the help Dale!

I think it was because I did not have it set to raw potentially.