PowerBI reading data format incorrectly

[Anonymous]

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.

[v-luwang-msft · Accepted solution]

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!

date format wrongly interpreted in Power BI (not the same as in Excel, the source file)

Best Regards

Lucien

[amitchandak]

@Anonymous , Make sure system date format is UK

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

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)))