The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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:
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?
Solved! Go to Solution.
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.
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.
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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
82 | |
64 | |
58 |
User | Count |
---|---|
248 | |
123 | |
112 | |
79 | |
78 |