Forum Discussion

JoRo's avatar
JoRo
New Member
4 years ago

Power Bi Service change date format

Hi

I am using Azure Stream Analytics with PBI. So I can't do what I want with PBI Desktop.

Initially the timestamp comes as text from Azure.

Then I adjust it to DateTIme in the settings of the dataset.

But then it shows it in MM/DD/YYYY instead of our DD/MM/YYYY.

Changing browser settings do not help here.

 

EDIT: THe same look on Android and iOS App.

 

Is there a way to change that?

 

 

Thanks

 

6 Replies

  • Hi JoRo 

     

    I am sure that you have to change the regional settings in Windows for this to work?

     

     

    • JoRo's avatar
      JoRo
      New Member

      My system is on my local settings, as well as my browser.  Everything else is displayed correctly. Every report I upload from Desktop is running fine.

      I think, this is due to the lack of defining the correct output in PBI Service.

       

      This is how it goes out of ASA:

      "time" : "2022-02-19T11:37:58.300+01:00",

      This is how it is displayed

      02.19.22 12:37:58 PM

      This is when I copy the value from a table in PBI Service

      Sat Feb 19 2022 12:37:58 GMT+0100 (Mitteleuropäische Normalzeit)

       

      systeminfo.exe:

      Systemgebietsschema: de;Deutsch (Deutschland)
      Eingabegebietsschema: de-ch;Deutsch (Schweiz)
      Zeitzone: (UTC+01:00) Amsterdam, Berlin, Bern, Rom, Stockholm, Wien

       

       

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User

        Hi JoRo 


        Can you change the format settings for the date column and see if that helps?

    • JoRo's avatar
      JoRo
      New Member

      Hi

      Doesn't help, still the same.

      It is even in the PowerBI App on iOS and Android the same.....