Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to Solution.
Literally worked like magic. Thank you so much!
User | Count |
---|---|
94 | |
83 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
62 |