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

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!

  • 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