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!
amitchandak
Super User
Super UserAnonymous , 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)))