Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Published report converts date to US format

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

Status: Delivered

Hi @Nalsey ,

This incident has been mitigated globally. I will close the thread.

 

Best regards,

Community Support Team_yanjiang

Comments
salmonman
New Member

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.

Dateformatsucks
New Member

same issue!

miquelmartorell
Advocate II

Same issue

v-yanjiang-msft
Community Support
Status changed to: Investigating

Hi @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

vyanjiangmsft_0-1681722742594.png

  • Once you click on Using Locale, a window pops-up with the below options

vyanjiangmsft_1-1681722742270.png

  • 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 II

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:


https://community.powerbi.com/t5/Service/Different-regional-configuration-Power-BI-Desktop-Power-BI/...

v-yanjiang-msft
Community Support
Status changed to: Accepted

Hi @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 II

The problem is fixed now in Spain. Thank you people.

 

Kind regards

Nalsey
Regular Visitor

Fixed. thank you.

liz72
Advocate I

Fixed in Australia