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 dat...
Need Help
GilbertQ's avatar
GilbertQ
Super User
4 years ago

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
4 years ago

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
    4 years ago

    Hi JoRo 


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

    • JoRo's avatar
      JoRo
      New Member
      4 years ago

      There I can only change the value alignment from left to right, etc.

      Tried them all, no change. Or are you thinking of someting else?