I use dd/mm/yyyy format on PBI desktop, but when published to online, that date is converted to US format mm/dd/yyyy.
This has only just happened in the last week or so. Worked fine for months prior. No changes have been made.
My default browser language is NZ, and in PBI desktop and service it is set to 'default (browser language)'. It has always been set to this.
But suddenly it has started being converted to US format. Please help!
Ben
14 Comments
- AnonymousNot applicable
Exact same issue, would love to know the fix if there is one. Default browser langauge is Australian English.
- liz72
Advocate I
Same. What has changed??? I thought it might have been a Chrome setting or PBI update but everything I have shows that it should still be in dd/mm/yyyy format yet my PBI online reports are showing mm/dd/yyyy.
- DateformatsucksNew Member
same issue!
- miquelmartorell
Advocate III
Same issue
- v-yanjiang-msft
Community Support
Status changed:NewtoInvestigatingHi Nalsey ,
Try the following steps to remedy that.
- Open your PBIX file > Go to Transform Editor (Power Query Editor)
- Select the Date Column > Right Click on Column Name> Change Type > Using Locale
- Once you click on Using Locale, a window pops-up with the below options
- Change Data Type to Date or DateTime and Locale to your desired locale type
- And click on OK and apply the transformations and publish to service
Best regards,
Community Support Team_yanjiang
- miquelmartorell
Advocate III
This is not a solution, I can't go table by table of each report editing this... moreover it happens also with the thousands separator and whole part part decimal separator as I reported here:
- v-yanjiang-msft
Community Support
Status changed:InvestigatingtoAcceptedHi Nalsey ,
It’s a known issue. The engineers are actively working on this issue and I will come back with an update if there is any progress.
Best Regards,
Community Support Team _ yanjiang - miquelmartorell
Advocate III
The problem is fixed now in Spain. Thank you people.
Kind regards
- NalseyRegular Visitor
Fixed. thank you.
- liz72
Advocate I
Fixed in Australia