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
I am trying to push some data to Power BI.
My json looks like this:
{
"Backup": "3",
"Restore": "1",
"DateTime": "2016-09-26T20:14:26:047Z"
}
The DateTime is a date in Power BI. If i try to post this I get a 400 bad request. If I dont have the DateTime in the json then everything works ok.
Solved! Go to Solution.
Thanks for the replies.
I have tried both:
{
"Backup": "1",
"Restore": "1",
"DateTime": "2016-09-28",
"Mirror": "2"
}
And
{
"Backup": "2",
"Restore": "1",
"DateTime": "2016-09-28 08:44:39"
}
I am still sure it has something to do with the date. If I remove the date time from the json it sends it up. The cell that is receiving the DateTime is a date on power bi side.
Based on my test, Neither Power BI desktop nor the REST API server(400 in my test) can recognize that format datetime string.
A formated string as "2016-09-26 20:14:26" should work.
@PatrickHart Maybe its the format of time stamp. Can you just try with Date without time.
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 |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |