cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itsmebvamsi
Responsive Resident
Responsive Resident

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
MMÜ
Frequent Visitor

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 @itsmebvamsi,

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.

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 @itsmebvamsi,

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

@itsmebvamsi - 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.


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition
amitchandak
Super User
Super User
Greg_Deckler
Super User
Super User

@itsmebvamsi - 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?


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors