date format is changed in power bi desktop

[Angel]

Hi, everybody

I am connecting Power BI Desktop with a query by ODATA.

This query has a column date format DD/MM/AAAA as it follows.

However, when I use the tag data to transform the format to date, it transforms DD/MM/AAAA by MM/DD/AAAA

I use this regional setting in Power Bi Desktop

Any tip?

Thanks for your help

[Eric_Zhang · Accepted solution]

@Angel

I don't know any Spanish, do you mean the problem is that the date column is predicated in "MM/DD/YYYY" rather than "DD/MM/YYYY" in that locale?

My text can be predicated in a "DD/MM/YYYY" format in the same locale in your post. I doubt the locale is overwritten in your case, check how the date type is changed in "advance editor" and try to find any code other than

= Table.TransformColumnTypes(Table5_Table, {{"date", type date}}, "es-ES")

You can also overwritten the locale forllowing below picture, right click on the column.

[Eric_Zhang · Accepted solution]

@Angel

I don't know any Spanish, do you mean the problem is that the date column is predicated in "MM/DD/YYYY" rather than "DD/MM/YYYY" in that locale?

My text can be predicated in a "DD/MM/YYYY" format in the same locale in your post. I doubt the locale is overwritten in your case, check how the date type is changed in "advance editor" and try to find any code other than

= Table.TransformColumnTypes(Table5_Table, {{"date", type date}}, "es-ES")

You can also overwritten the locale forllowing below picture, right click on the column.

[Angel · Accepted solution]

Thanks!!!!

It works!!!!