Date formatting issues MM/DD/YYYY --> DD/MM/YYYY

[Anonymous]

I have a temperature sensor connected to Power BI Service through an API data stream. The sensor writes an eventID, a temperature value and a timestamp by using Microsoft Flow. 

I have issues with the date formatting. I want Power BI to read it as DD/MM/YYYY HH:mm (24 hour clock), but it reads it as MM/DD/YYYY hh:mm (12 hour clock). 

I run the following command in MS Flow to format the time: 

convertTimeZone(triggerBody()?['event']?['timestamp'], 'UTC', 'W. Europe Standard Time', 'dd/MM/yyyy HH:mm') 

I think this works properly. 

I have tried to set the language in Power BI Service to Norwegian (which uses DD/MM/YYY format) and English (UK) but it does not work. I have also tried to set the browser language to Norwegian or English (UK) and set Power BI language to browser default. This does not work either. 

As the data is gathered with APIs in Power BI Service, I cannot create a column with DAX converting the date to DD/MM/YYYY. 

Any suggestions are welcome!

[Rajiv]

I was having a lot of issues while using DD/MM/YYYY and dd/mm/yyyy along with time stamp. The dates never came correctly. Took a while to figure out the mm and MM makes a lot of difference. For dates we need dd/MM/yyyy (M in capital). mm refers to minutes. So when I was using dd/mm/yyyy, I was getting values like 15/56/2020. The capital Ms fixed it.

[chthomama]

Hi there

i'm facing a similar issue. Have you found a solution or workaround?

Thanks for your help

[Anonymous]

Hi,

I forgot to accept the solution proposed here, sorry about that 🙂

[chthomama]

Hi andrmi,

thanks for your quick reply.

I managed to get the right date format with following statement:

convertTimeZone(body('Antwortdetails_abrufen')?['submitDate'], 'UTC', 'W. Europe Standard Time', 'dd/MM/yyyy HH:mm')

but i still have the problem with the time! I get 12 hours digits instead of the 24 digits? Any idea?

[Anonymous]

Hi,

You may have to change the language settings i Power BI Service to get 24 hour clock format. Log into Power BI Service, click the settings button, then settings and language. Select your language (which I assume uses 24 hour format). 

If this does not work, try the following: https://community.powerbi.com/t5/Service/changing-timezone-of-powerbi-service/td-p/153663 

[chthomama]

The language settings are just fine. Then the other proposed solution is also not working, because i've a streaming data set and i am not able to add own columns with the query editor.

[Anonymous]

Then I am out of ideas, sorry!

[chthomama]

Thanks ayway! 🙂

Now i actually found the problem, but for me this seems more like a bug. Following situation:

When i change the X graph of the visuals to continuos the 24 format of the time applies. If i change it back to "categorical" its again the 12 hour format.

Isn't that a strange behavior?

[Anonymous]

Sounds strange. I suggest you post it as a bug in issues forum: https://community.powerbi.com/t5/Issues/idb-p/Issues 

[Greg_Deckler · Accepted solution]

Why not just adjust your Flow?

convertTimeZone(triggerBody()?['event']?['timestamp'], 'UTC', 'W. Europe Standard Time', 'MM/dd/yyyy HH:mm')