Forum Discussion
Service Reformatting Specific Date Values
Hi everyone, I have a spreadsheet connected to PBI desktop and the gateway for service. When the dataset is refreshed through the service, the date format changes from DD/MM/YYY to MM/DD/YYY...
If you could try to update the power bi desktop to the latest version and try it again.
https://www.microsoft.com/en-us/download/details.aspx?id=58494
and you could also change the date type with locale
https://radacad.com/flawless-date-conversion-in-power-query
Regards,
Lin
This is what's happening:
On desktop is looks fine, like this:
When I publish to service, the date format from the 5th to the 13th change for each month... like so
This is happening for each month, which you can see in the plateaus...
I'm not sure why the dates are only changing for a specific date... v-lili6-msft
