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.

LizHackett's avatar
LizHackett
Regular Visitor
9 years ago

Hi irmat,

I had the same problem as saunders (in Eastern Australia as well) and I've changed my date format under Windows Region settings to the long format dd/mm/yyyy, but still having the same issue.

Am I changing the date format in the wrong place?  If so, where should I be changing it?

 

In Query editor I changed the type to Date (as it comes through as text via a web link to a dataset from Blackbaud CRM) and getting an error on those dates in which the day is above 12. 

 

 

 

 

 

 

 

 

 

 

 

Thanks!

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!