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!

mmmg's avatar
mmmg
Frequent Visitor
6 years ago

Hi LizHackett,

you're on the right track. I tried all of the changing regional settings and changing the date settings via the Modelling menu in Power BI. None of them worked. I then tried changing the Data Type of my date fields via the Query Editor icon in the Home ribbon. I needed to do this because my date fields are varchars in my source table. Once I did this I clicked on Close and Apply, saved my report and then published - the dates are now staying as dd/mm/yyyy (I'm in Sydney). So the problem all along was that my date fields were varchars. Hope this helps