Changing model language

[ivgo]

Hi, everybody. I have a question about date part languages displayed in Power BI.

I have .pbix file with SQL Server data source. There is dimDate table with Date field. This field, when I use it in visualizations is expanded to 4 levels:

• Jahr
• Quartal
• Monat
• Tag

I want to change language of this date parts to English.

It is described in article: https://docs.microsoft.com/en-us/power-bi/supported-languages-countries-regions, that Model language has to be changed.

The problem is that there is no Regional Settings section under Global. (File > Options and settings > Options)

I see:

...

Security

Privacy

...

Power BI desktop version: Version: 2.53.4954.621 64-bit (December 2017)

There is only Regional Settings under CURRENT FILE and I already changed it to English, but it did not helped.

How can I change language for automatiaclly generated date part fields?

[v-chuncz-msft · Accepted solution]

@ivgo,

By the way, function Date.ToText could be used in Query Editor. For a list of culture names, see National Language Support (NLS) API Reference.

[WolfBiber]

Hey,

I also experimented with regional settings. I think it is a bug, because in PBID only the System Language is taken for Language settings in datamodel.

greetings

[ivgo]

It looks like that System Language, of the system where file was created is somehow hardcoded into the pbix file. English is used everywhere on my PC, but these fields are still in German, and I can't change it.

[WolfBiber]

what is you profile language?

You can find these settings in the top right corner of PBID

[ivgo]

English.

I consider this model language is inherited from Power Pivot, as there were no option to change languge for DAX FORMAT function.

It is known issue. There is already topic about that problem. With suggestion to create a custom heirarchy

https://community.powerbi.com/t5/Desktop/How-to-change-the-date-language-for-an-existing-pbix-file/t...