Forum Discussion

eheidari's avatar
eheidari
Frequent Visitor
9 years ago
Solved

Date format will be US format after publishing ...

Hi everyone,

I've created my report in power bi desktop that is using Direc Query.

I have Date slicer in my report and the display format is Australian format (Exactly what I need). for example "31/12/2016"

The Date Value in SQL server database is like "2000-01-24 00:00:00.000"  and data type for this column is Datetime.

The language setting in my computer and also in power bi desktop is "English(Australia)"  and language in power bi service is English.

After publishing the report ,I see Date format will change to US format, it is "12/31/2016".

 

Do you know what is the reason and how can I fix it please?

 

Thanks,

Emma

Need Help

13 Replies

    • eheidari's avatar
      eheidari
      Frequent Visitor
      9 years ago

      Thanks a lot Simon,

       

      With following the link that you've sent, my problem was fixed.

       

      Regards,

      Emma

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Emma,

     

    Did you check the date formating? You can change the format here:

     

    • eheidari's avatar
      eheidari
      Frequent Visitor
      9 years ago

      Hi Revanth,

       

      The Date type and Format are disable in modeling tab, is that because of direct query connection... ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        It shouldn't be because of direct query. It works for me even with direct query. I'm connceting to SQL Server database.

         

        And btw you should be selecting the date field from fields list before you try to change the format.

  • RIchardGaveyXP's avatar
    RIchardGaveyXP
    New Member
    3 years ago

    Probably a bit late now, but i had the same thing tonight, November 2022 in New Zealand. Perfect in PowerBI desktop, American when published. 

    I went into the PowerBI service > settings. (1) & (2)

    Into General and Language > selected "browser default".  (3) & (4)

    It seems "english" from the dropdown list actually means "American English". 
    Setting it to browser default lets Chrome/Edge define how to show the data. If you're in a multi-national organisation like I am that definitely helps!

     

    Hope this helps someone not spend hours looking like I did!