Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
itsmebvk
Continued Contributor
Continued Contributor

Identify user language PBI Desktop and PBI service?

 

Hi Folks,

 

We are trying to create multiple lingual reports using PBI.

 

I have a question, Is there any function in PBI which identifies which language we are using in PBI desktop (PBI interface language) or PBI Service or desktop or Browser language?

 

I understood that we can provide a prompt to user to select the language in which they want to run PBI reports,  but we are looking for some dynamic way of doing it. 

 

Please share if you have any thoughts or inputs to fulfill above requirement.

 

Thanks in advance.

 

7 REPLIES 7
Anonymous
Not applicable

The DAX function

 

USERCULTURE()

 

will give you the current users locale. The first two characters essentially provide you with the users language. You can use this in your DAX to your liking. However this function is not documented and not officially supported by Microsoft. So be careful when using it in production 😉

 

With this and tabular editor you can pretty much accomplish a true multilanguage report.

v-shex-msft
Community Support
Community Support

Hi @itsmebvk,

In fact, power bi data model existing 'Culture' information, but it seems like power bi not contain any availed DAX functions and features to pick up the current data model culture.

Changing the culture of a Power BI Desktop file 

Perhaps you can try to use R or python visual with scripts to get current system culture info.

How to detect the OS default language in python? 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
itsmebvk
Continued Contributor
Continued Contributor

Thanks @Greg_Deckler  @v-shex-msft  @amitchandak  for your replies, as you have mentioned since there is no direct option I will try all work around suggested by you.

 

Appreciate your help!

Hi @itsmebvk,

Yes, current power bi seems not to share the options to achieve your requirement. BTW, submit an idea to add official support with this might be a simple way to further developing with data model culture fields.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Greg_Deckler
Super User
Super User

@itsmebvk - To be clear, there is no DAX function that will identify the language that I am aware of. Also, Power Query won't help because that's only for data load. You could have a custom visual with javascript that could probably do it but not sure if that is useful or not.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

@itsmebvk , refer if these can help

https://www.powerbi-pro.com/en/creating-multilingual-reports-in-power-bi/
https://community.powerbi.com/t5/Desktop/How-to-create-Multilingual-Report-in-Power-BI/td-p/599696
https://www.youtube.com/watch?v=JJryD2dXVVw

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Greg_Deckler
Super User
Super User

@itsmebvk - It is my undestanding that you can use Tabular Editor to create, essentially, language variations of table names, column names, measures etc. In this case then, these will show up automatically according to each user's regional language setting. Is that what you are going for?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.