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.

irmat's avatar
irmat
Advocate II
9 years ago

Hi LizHackett

Have you maybe tried the below

or changing it to English (Australia)? You will have to restart Power BI Desktop after this change.

 

 

LizHackett's avatar
LizHackett
Regular Visitor
9 years ago

Hi irmat

Thanks!! The first solution you suggested to change the date format under Modelling within Desktop  (not in query editor) to dd/mm/yyyy worked :)
I made sure I had my location in Desktop set to Australia.

Thanks for your help!