Forum Discussion
jannahds
6 years agoHelper I
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: