400 when pushing a date to Power BI

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.

ankitpatira
Community Champion
9 years ago
PatrickHart Maybe its the format of time stamp. Can you just try with Date without time.
Eric_Zhang
Microsoft Employee
9 years ago
PatrickHart

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
Regular Visitor
9 years ago
@AnkitPatira
@Eric_Zhang

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.
- sirui_sun
  Microsoft Employee
  9 years ago
  
  Hey Patrick -
  
  Here is an example of a date string that Power BI expects:
  
  "2016-09-30T00:13:00.107Z"
  
  You can see this by going to streaming datasets, and creating an API streaming dataset with data of type DateTime.
  
  I noticed that in your initial example, you had another colon between seconds and milliseconds - have you tried your initial format but with a period instead of colon?

Forum Discussion