Multilingual reports

[abansalgeoforce]

We have a use case where we need to convert the PowerBi report into multiple languages (Spanish, French, Portugese). What we mean is -
1) The column names, chart names, text should all change to the required language.
2) When a user exports, it should export in that specific language.

How can this be done? Also, does it need specific type of license to achieve it?

[v-hashadapu]

Hi @abansalgeoforce , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

[v-hashadapu]

Hi @abansalgeoforce , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[abansalgeoforce]

Using translator buider, we are able to easily translate the table names, column names and field names.

Howeverm it doesn't update the titles on the KPIs (tiles), or Charts titles, axis etc.
I think we probably need to create DAX functions for each of those. Is that correct understading?

[v-hashadapu · Accepted solution]

Hi @abansalgeoforce , Thank you for reaching out to the Microsoft Community Forum.

The translations you applied through Translator Builder or Tabular Editor only cover model metadata (table names, column names, measure names). Power BI does not translate report layer text such as KPI titles, chart titles, axis labels or text boxes. Those elements must be made dynamic by returning translated strings from the model.

The standard pattern is a Translation table (Language, Key, Text), a language selector and a DAX measure that looks up the appropriate text. You then bind that measure to each visual’s title/axis via Format -> fx -> Field value. For visuals or properties that don’t support field value formatting, you overlay a Card/Text box driven by the measure. Exports will reflect whatever language is rendered on screen. No special license is required.

Expression-based titles in Power BI Desktop - Power BI | Microsoft Learn

Create Multiple-Language Reports with Translations Builder - Power BI | Microsoft Learn

Plan Translation for Multiple-Language Reports in Power BI - Power BI | Microsoft Learn

[v-hashadapu]

Hi @abansalgeoforce , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @rohit1991  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

Thank you @rohit1991  for your valuable response.

[Zanqueta]

Hi @abansalgeoforce,

I use Tabular Editor and strongly recommend it to achieve this goal. Please take a look at the links below for more details.

https://tabulareditor.com/blog/creating-multilingual-power-bi-dataset 

Or check this other topics:

Solved: How to create Multilingual Report in Power BI ? - Microsoft Fabric Community

Solved: Multilingual reports - Microsoft Fabric Community

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.

[Anand24]

Hi @abansalgeoforce,
Look at these threads:
1. https://community.fabric.microsoft.com/t5/Desktop/multilingual-reports-in-power-bi/m-p/4824446

2. https://community.fabric.microsoft.com/t5/Desktop/Multilingual-reports-in-Power-BI/m-p/4115556

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[rohit1991]

Hii @abansalgeoforce 

You can make a Power BI report multilingual by storing all translations (column names, titles, labels, etc.) in a separate translation table and switching text dynamically based on a language slicer. Every visual title and column header must use a DAX measure that returns the translated text (Power BI does not automatically translate metadata). Exported files also follow whatever text is shown on screen, so users will get the export in the selected language. No special license is required  this works in Pro, Premium Per User, and Premium capacities.