Forum Discussion

jannahds's avatar
jannahds
Helper I
6 years ago
Solved

Parse DateTime

Hi there,

I'm loading datetime data to Power BI Desktop using the Power Query.

I'm pulling the data in from Excel.

The date value in the Excel looks like this:

2020-03-29T12:27:49.525+03:00

 

But when I change the "type" of the ColumnType in the Power Query, it just gives an Error - with message: 

DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Details:
2020-03-29T12:27:49.525+03:00

 

Can someone help me understand how to specify a DateTime format in this format?

 

A picture of what it looks like:

2 Replies