Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape 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.
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.
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.
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
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
@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.
@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
@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?
User | Count |
---|---|
90 | |
88 | |
87 | |
79 | |
49 |
User | Count |
---|---|
153 | |
145 | |
106 | |
74 | |
55 |