Power Bi Service change date format

[JoRo]

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

[v-yalanwu-msft]

Hi, @JoRo ;
You can check if these related post can is useful to you.

The issue is caused by a combination of the settings in the Power BI Service and the settings in your browser. 

https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JoRo]

Hi

Doesn't help, still the same.

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

[GilbertQ]

Hi @JoRo 

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

[JoRo]

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]

Hi @JoRo 

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

[JoRo]

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?