Parse DateTime

[jannahds]

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:

[az38 · Accepted solution]

Hi @jannahds 

set datetype as datetimezone

[jannahds]

Literally worked like magic.  Thank you so much!