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 and not adopt the US format? 

 

Note that our PowerBI tenant is in the Australia South East region so I don't know why dates in the service are showing in US format.

 

Any advice much appreciated.

 

Thanks,

Ed

 

Desktop version:

 

Service version:

  • 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.

12 Replies

  • MatE's avatar
    MatE
    Frequent Visitor
    6 years ago

    Hi All,

     

    I went through all the changes that you have mentioned here. However, Power BI service did not display the date format(dd/mm/yyyy) until I change the browser language. 

    In this case, I was using Chrome. 

    Chrome -> settings -> Default browser -> Language -> Add language -> Make sure that you have the correct language setting at the top. 

  • 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,

    • saunders's avatar
      saunders
      Helper II
      9 years ago

      Hi Simon, thanks for your reply.  I've investigated this more and it seems that, when there is a live connection to Analysis Services or when there is DirectQuery connection to SQL Server, PowerBI displays the US format, not the local format.

       

      Is there anyone else who is experiencing this?

       

      Thanks!

       

      Analysis Service - Import (correct)

       

       

      Analysis Service - Live Connection (incorrect)

       

       

       

      SQL Server - DirectQuery (incorrect)

       

       

       

      • 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.

  • MaxGrispen's avatar
    MaxGrispen
    New Member
    5 years ago

    Hi All, 

     

    I have te same problem but nothing from the above works. 

    My desktop is set to Dutch language same for my Power Bi Desktop. Format is (dd/MM/yyy)

    When I make the upload everything is fine. But when I make a refresh it changes all my dates to (MM/dd/yyyy) tough my Power BI Service Language is set to Dutch aswell. 

     

    Hope you guys can help