power bi tranforms date in format mmddyyy instead of ddmmyyyy

[erdinch]

Hello,

I have very simple problem. There is a column that contains date in format DD.MM.YYYY.

for example:

12.01.2023

13.01.2023

For some reason PBI expectation for the date format is MMDDYYYY.

When I reach the  step "promote header" and change type power bi transforms that column into date in format MMDDYYYY

that unfortunately alters the first date to 1st of december and the second date is giving error.

How to overcome that?

[grantsamborn]

Hi @erdinch 

While in Power Query, you can change the type of that column by using "Using Locale".

In the dialog box, choose Date as the data type and for Locale, choose a locale that has the DD.MM.YYYY format.  (ie. "English (Netherlands)" )

Let me know if this doesn't help.

[andhiii079845]

You do it in the Power Query Editor? Perhaps change the data format in the Editor?
I insert 01.10.2022 in a new table, delete the automatic data type change step and than change the data type for me own.