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.
Dear members,
I have a file which contains all the transactions and tickets generated for the last month from our ticketing system. The thing is the column for created time is in text format. Issue happens when i wanted to convert the column to Date. As a result, some fields were successfully converted and some fields have "Error". Please refer the image below emove these errors as they will affect my reporting and tracking process. The error message is "DataFormat.Error: We couldn't parse the input provided as a DateTime value". The sample is available here for your reference Sample Data Set.xls
Solved! Go to Solution.
Hey @bahare76 ,
for me it worked without any errors with your data.
Can you tell me the error?
Otherwise this happens for me once in a while when I import data in another locale format, like US format and I'm in Europe.
Try to import as with locale. Important, you have to do that when the column is still in format text.
Right click on the column --> Change Type --> Using Locale:
Then chose Date/Time and Locale English (US):
Afterwards he tries to make a datetime field from the US format.
Let me know if that worked.
Hey @bahare76 ,
for me it worked without any errors with your data.
Can you tell me the error?
Otherwise this happens for me once in a while when I import data in another locale format, like US format and I'm in Europe.
Try to import as with locale. Important, you have to do that when the column is still in format text.
Right click on the column --> Change Type --> Using Locale:
Then chose Date/Time and Locale English (US):
Afterwards he tries to make a datetime field from the US format.
Let me know if that worked.
I tried changing type using locale, but 2023 gets changed to 1905 year - why is it so?
In my case I got date column in text format and I trying to convert the column into the date format .It is able to convert the intial dates but ultimatley when I am scrolling down then there are errors and even my os regional language(english India ) and power bi 's regional language are same and I also even tried this convert date according to locale method but still problem is not getting resolved.
Hi @selimovd ,
Thanks, it worked. What i did was changing the regional setting before converting to Date Format.
Hey @bahare76 ,
that's great to hear! Yes, you have to change it before the conversion, otherwise the error already exists 😊
Don't forget to mark the post as solution ✔️, like that you help the next person to find the result without reading through the whole conversation.
Best regards and have great Easter
Denis
@bahare76 , I do not see any date in the excel link.
This can be because your date is in dd/mm/yyyy format and you have a setting of windows mm/dd/yyyy
Other way is to convert date to other format - I dicussed in this video https://www.youtube.com/watch?v=vky4wPqm0O0
One way is this setting - https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |