cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Angel
Resolver III
Resolver III

date format is changed in power bi desktop

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.

 

DateInQuery.JPG

 

 

 

 

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

 

Afterformatdate.JPG

 

I use this regional setting in Power Bi Desktop

 

RegionalSetting.JPG

 

 

 

Any tip?

 

Thanks for your help

 

 

2 ACCEPTED SOLUTIONS
Eric_Zhang
Microsoft
Microsoft

@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.
Capture.PNG

View solution in original post

Thanks!!!!

 

It works!!!!

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft
Microsoft

@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.
Capture.PNG

View solution in original post

Thanks!!!!

 

It works!!!!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.