cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to change the date language for an existing pbix file?

Hi,

I've been trying to look everywhere but can't find a solution to this problem:

 

I have a pbix file that was created in a PowerBI in italian. I'm using an English version of PowerBI, but months and quarters are still shown in italian!

 

If I were to create a new file, the date hierarchy would show in english, but I can't recreate the pbix from scratch as it contains almost 100 complex reports and views.

 

Please help me figure out how to change the date hierarchy languange.

 

I read also the thread https://community.powerbi.com/t5/Desktop/Change-language-in-date-year-month-day/m-p/75731/highlight/..., but can't find a solution.

 

I also tried to look "inside" the pbix to see if the original locale was stored anyware, but could only find a Timeline.js file that contains the correct values (english) for months and quarters..

 

Thank you very much!

Michael

 

13 REPLIES 13
Highlighted
Microsoft
Microsoft

Re: How to change the date language for an existing pbix file?

Hi @miksantoro,

 

This is by design and there is no option to change it currently. The Product Team have created a Design Change Request in the internal system for tracking. Smiley Happy

 

Regards

Highlighted
Frequent Visitor

Re: How to change the date language for an existing pbix file?

Thank you @v-ljerr-msft for the info.

Do you know if there's any way to accomplish something similar, like an extract/import, or a special save as?

What is the usual timing for a CR?

 

Thank you,

Michael

Highlighted
Microsoft
Microsoft

Re: How to change the date language for an existing pbix file?

Hi @miksantoro,


Do you know if there's any way to accomplish something similar, like an extract/import, or a special save as?


After a few try, I still cannot find a possible solution to workaround this.


What is the usual timing for a CR?


I have no idea of what the usual timing is, but I will try to confirm it with others, and let you know if I can get some response from them. Smiley Happy

 

Regards

Highlighted
New Member

Re: How to change the date language for an existing pbix file?

Hello!

 

Is there any news related to this issue?

 

We need it too 🙂

Highlighted
New Member

Re: How to change the date language for an existing pbix file?

Hello!

 

Is there any news related to this issue?

 

We need it too 🙂

Highlighted
Frequent Visitor

Re: How to change the date language for an existing pbix file?

Hi @m_miracle, no news as of now.

Hopefully @v-ljerr-msft can come back with some updates. But I guess the implementation of the solution will require some longer time. So my suggestion to you is to recreate the reports to avoid the language issue.

 

Thanks,

Michael

Highlighted
Frequent Visitor

Re: How to change the date language for an existing pbix file?

This is a needed feature. As in desperately needed.  English users are tasked with viewing Chinese dates in some of the cases impacting my user community.  #notgood

Highlighted
Post Patron
Post Patron

Re: How to change the date language for an existing pbix file?

Highlighted
Frequent Visitor

Re: How to change the date language for an existing pbix file?

.PBIX was originally written using a Desktop client set to Chinese (simplified).  Before posting original post, I did attempt to change the 'Locale' settings to English.  I saved the .pbix, closed the desktop, re-launched the desktop and no change.2017-08-17_16-37-19.jpg

The reports will be consumed by users Globally, so I need to have the .pbix files in English.  I think the only way to do that now is to have the developer in China set his desktop client to English when creating the .pbix.

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors