AG_x11x
2 years agoFrequent Visitor
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 ...
Anonymous
2 years agoNot applicable
I am facing the same issue except my issue is with the parameter. Everything else in the report is fine but parameter's date format changes from Australian DD/MM/YYYY format to US MM/DD/YYYY when Power BI Report is published to Online Service.
I've checked everything that I could think of and as far as I know Region / Format is all set to English (Australia).
I have cleared cashe and re-published the report but it didn't work.
My parameter is very simple - just one parameter to work out last 12 months data.
Parameter Type is "Date" and Suggested Values "Any value".
Any help appreciated.