Forum Discussion
Helper IInterpretation error in date column between Power BI Desktop and Power BI Service
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?
2 Replies
- ibarrau
Super User
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.
I hope that help,s
AndresEstebanHello, 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.
