Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

kewaynes

USERCULTURE() Returns Incorrect Locale for Serbian

Submitted by Helper IV on ‎10-17-2024 05:09 AM

I have a report that needs to translate metadata. However, I am running into an issue with Serbian. The issue is that when my browser is set up for sr-Latn-RS, USERCULTURE() returns sr-Latn-CS. This is preventing the language translations from occurring.

kewaynes_0-1729166844531.png

My understanding is that this is the old serbian latin code and is deprecated. Shouldn't USERCULTURE() return sr-Latn-RS?

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
Anonymous
Not applicable
‎10-17-2024 11:36 PM

Hi  @kewaynes 

What is your Language Settings in Power BI Service ?  Based on feedback from the relevant documentation, the default is determined by the user's browser language setting.

https://learn.microsoft.com/en-us/dax/userculture-function-dax#remarks

 

Best Regards,
Community Support Team _ Ailsa Tao

kewaynes
Helper IV
Helper IV
‎10-18-2024 06:28 AM

Hi. Thanks for the response.

 

The display language is set to default to my browser langauge, which is English. And everything does return in English unless I override it with a hardcoded language. When I do this with sr-Latn-RS, the workspace does translate to Serbian.

kewaynes_0-1729257517879.png

But the issue I still run into is that Tabular Editor (what I use for metadata translations in the report) is expecting the sr-Latn-RS. But the Power BI report is returning sr-Latn-CS as can be seen by the USERCULTURE() function in the above image. 

 

From what I have read online, the sr-Latn-CS is the old language code and was replaced by sr-Latn-RS some time back. My understanding is that sr-Latn-CS has been deprecated. It isn't even in the supported list of Serbian locals in Tabular Editor. 

kewaynes_1-1729257912753.png

 

I have reached out to the Tabular Editor team. They said they will investigate further and get back to me, but the initial response was:

'To my knowledge, Tabular Editor displays the cultures available through the .NET framework installed on your local machine. Since sr-Latn-CS is deprecated, it will not be shown.'

We support a few dozen languages and I haven't run into this issue with any of the others. Whatever I change the browser locale to (by hardcoding the language in the URL), that is what the USERCULTURE() function returns in the report and the metada translations work as expected.

 

kewaynes
Helper IV
Helper IV
‎10-22-2024 05:04 AM

Hi Ailsa. Just following up on this. Is there any other information that I could provide to help clarify the issue that I'm running into?

kewaynes
Helper IV
Helper IV
‎11-01-2024 07:09 AM

Hi Ailsa,

 

Wanted to follow up on this one more time. I'm just wondering if you or anyone on the support team is able to replicate this and thinks that it is needs changed so that USERCULTURE() returned sr-Latn-RS like expected. 

 

I have some ideas to bandaid the report for the Serbian translations, but it would of course be extra work and make the report messier. So if there was intention from Microsoft to change this so that sr-Latn-RS is indeed returned like expected, my team wouldn't need to go through all the extra work. 

 

Just let me know your thoughts. Thanks 

Idea Statuses