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.

JESLIN's avatar
JESLIN
New Member
2 years ago

Hi,

I am located in Australia ,  and have changed all setting to English(Australia) - computer/Edge/Chorme/Power BI.   The Date formate in Desktop and All shown in Edge are accurate in Australia mode.  But the date formate is still in US mode in Google Chrome even the setting is in Australia mode.   could you advise any setting need to change if BI report is shown in Chrome ?