Forum Discussion
PowerBI reading data format incorrectly
On an excel sheet I have the date in plain text in the format dd/mm/yyyy. However, when I import it to PowerBI and change the data type of the column it reads it as mm/dd/yyyy. I don't have edit...
Hi Anonymous ，
You have enabled automatic date conversion in Power BI, you can turn it off, or go to transform and delete the conversion step.And you could test the below:
Date.FromText(Text.From([Date]), "de-DE")Refer the below similar case ,wish it is helpful for you!
v-luwang-msft
Community Support
Community SupportHi Anonymous ，
You have enabled automatic date conversion in Power BI, you can turn it off, or go to transform and delete the conversion step.And you could test the below:
Date.FromText(Text.From([Date]), "de-DE")
Refer the below similar case ,wish it is helpful for you!