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 rights over the excel sheet so can't change how it's stored.
My locale is set to UK in options so I'm unsure what's causing this.
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!
2 Replies
Anonymous , Make sure system date format is UK
or mark that as text first and then convert it to the date
date(( right(DD__MM__YY[date],4)), (mid(DD__MM__YY[date],4,2)) ,(left(DD__MM__YY[date],2)))
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!
