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...
Hey RenataOG30s ,
there seems to be a problem with the conversion from the date. Make sure before any other conversion in your data flow, that you chose "Change type" --> "Using Locale"
Then you have to choose the format of the date, most likely it's from the United States:
Like this Power Query will convert your data as date with the format from US.
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 regards
Denis
Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic
Hi Denis, thank you so much for your reply. Unfortuntely, I tried that and didn't work. It should be English UK. I tried changing the regional settings, but no success.