Forum Discussion

PatrickHart's avatar
PatrickHart
Regular Visitor
9 years ago
Solved

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...
  • sirui_sun's avatar
    sirui_sun
    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?
     
PatrickHart's avatar
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's avatar
    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?