Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm getting I'm getting an error in date/time fields with SharePoint Online list, this is when using the 2.0 (Beta) implementation.
Note: I don't have this issue when using the 1.0 implementation (which is a bit slower).
The error mesage I'm getting is:
DataFormat.Error: We couldn't parse the input provided as a DateTime value.
Details:
16/11/2020 18:04
I've tried changing the locale (to English UK), but no luck so far.
Solved! Go to Solution.
Today, I refreshed my query, and the issue has magically fixed itself.
I believe this is an issue caused by my locale settings: I checked the following
Today, I refreshed my query, and the issue has magically fixed itself.
I believe this is an issue caused by my locale settings: I checked the following
Hi @dantshin ,
Could you provide an image of the dates so that we are able to see if there are any issues directly.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liang,
Here you go:
Add a Replace Values step on that column replacing the space with a "T" before you try to change to DateTime.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi Pat,
Unfortunately, that doesn't work. Even before I can change the type, Power Query is already determining the column type - it already knows it is a Date/Time type.
Here is a screenshot in PowerQuery right after I've selected the list (in the Navigation step). I haven't had a chance to change the type yet.
I do wonder if it's something to do with the locale - as some dates do make it through (if either month or date is 12 or less) - but I have already forced the locale to be en-GB (English-UK)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |