Forum Discussion
Error when converting text to date with Power BI
Hey Anonymous ,
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.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.bi
Most Valuable ProfessionalHey Anonymous ,
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.
Hi selimovd ,
Thanks, it worked. What i did was changing the regional setting before converting to Date Format.
- selimovd
Hey Anonymous ,
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