Interpretation error in date column between Power BI Desktop and Power BI Service

[AndresEsteban]

I have the following problem. I create a report in Power BI Desktop where the date column has the format dd/mm/yyyy. This date column is used both to perform calculations and to apply it in a filter. In Power BI Desktop it works correctly, however, when publishing in Power BI Service it does not interpret this column correctly and some dates are interpreted with mm/dd/yyyy format. For example, 03/07/2023 (dd/mm/yyyy) is well interpreted in Desktop but in Service it is interpreted as 07/03/2023 (dd/mm/yyyy), that is, it changes the month and day.

Does anyone know how to solve this?

[AndresEsteban]

Hello, thank you for your help. The problem is that the data import brings a column in UNIX format and, therefore, first I transform it to datetime.

[ibarrau]

Hi. You can try changing the date type to a local date type culture.

Check this post out to make the change for the column at transform data menu.

https://community.fabric.microsoft.com/t5/Power-Query/How-to-configure-power-query-date-as-dd-mm-yyy...

I hope that help,s