Forum Discussion
Changing model language
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?
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.
5 Replies
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
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.
what is you profile language?
You can find these settings in the top right corner of PBID
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.
