AG_x11x's avatar
AG_x11x
Frequent Visitor
2 years ago
Status:
Investigating

Published PBI report file converts date to US format

Hi Friends,   I used dd/mm/yyyy  HH:MM:SS AM/PM format on PBI desktop file, but when published to my workspace online (power bi pro user), that date is converted to US format mm/dd/yyyy HH:MM:SS ...
Dashboards
Report Server
Reports
AG_x11x's avatar
AG_x11x
Frequent Visitor
2 years ago

Anonymous

 

Thanks for your message! Yes, i've deleted then re-uploaded and the issue continued. Yes, I made sure my chrome browser language settings is english(Australia).

 

Also, now it is visualising correctly in Australian format but when I use the "export data" from a table with the date... it exports with an American date style not what is visualised on the published version or power bi desktop file. However, when i extract data from power bi desktop file - the date column remains in Australian date format as visualised.

 

example: 

In power bi desktop:

1/07/2023 10:00:05 AM
17/07/2023 9:55:00 AM 

27/07/2023 2:25:00 PM

published version showed as:
1/07/2023 10:00:05 AM 
17/07/2023 9:55:00 AM 

27/07/2023 2:25:00 PM

 

exported version data shows as: 

7/1/2023 10:00:05 AM 

7/17/2023 9:55:00 AM 

7/27/2023 2:25:00 PM

 

Completed Ideas