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.

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

saunders

 

In Power BI Desktop, it takes the date format of local machine.

 



 

However, I can't reproduce your issue. When I publish a report with "d/MM/yyyy" date format onto Power BI Service, it will keeps same format.

 

 

Can you republish your .pbix again to see if it works properlly?

 

Regards,