Forum Discussion

saunders's avatar
saunders
Helper II
9 years ago
Solved

Date format - Desktop vs. Service

Hi all,   I have dates formatted as dd/mm/yyyy in Desktop but when I publish to the service the format get changed to mm/dd/yyyy.  How can I force the service to respect my Australian date format a...
  • irmat's avatar
    irmat
    9 years ago

    saunders

    Hi,

    I had the same issue by using SSAS. I noticed that in SSAS the data on the data format on the date column was set to either General or short date. Setting the data format to dd/MM/yyyy fixed the issue.

    Hope this helps.

MaxGrispen's avatar
MaxGrispen
New Member
5 years ago

Hi All, 

 

I have te same problem but nothing from the above works. 

My desktop is set to Dutch language same for my Power Bi Desktop. Format is (dd/MM/yyy)

When I make the upload everything is fine. But when I make a refresh it changes all my dates to (MM/dd/yyyy) tough my Power BI Service Language is set to Dutch aswell. 

 

Hope you guys can help