Forum Discussion
Date format issue
Hi everyone, can you please help me with the issue I'm facing. My Date table is a csv file and it works completely fine in PBI Desktop, but I'm re-creating the same dataset as a Dataflow, but for so...
Hi RenataOG30s
Change type by using locale should work, you need to select English (United Kingdom) here as it expects the locale of original data. After changing column type, you will see data in the format which is identical with your account/browser settings. I guess your account/browser settings is using English(United States) so you will get result in that format. That's also why you have this error initially when changing data type.
If you want to see datatime in English (United Kingdom) format, you could refer to https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.