How to configure translation in Inforiver based on language setting in Power BI

What is Localization settings?

If your report has a global audience, you can configure calculated rows/columns or column groups to display dimension categories based on pre-defined translations when the language is switched.

How to set this inside Inforiver?

Step1. Navigate to Display Settings > General > Localization Settings to create translation entries.

Step2. You can translate the key word and enter the respective German/French or any other language name.

E.g i have given Furniture and Office Supply name with German word prefix.

Step 3. Now will create a New Calculated Row with Name using GETLOCALELABEL Function.

Use the existing Row or Column name to be change with GETLOCALELABEL() with text in single quotes.

Step4. Once you save the report and publish it in PowerBI service.

Depending on your Power BI Language setting the report will display the data as per the keyword.

e.g In the below example Power BI language set to Germany.

Finally, when viewing the report will show the respective language name.

GETLOCALELABEL. This function translates the provided text into the language set in the Power BI service.

Syntax : GETLOCALELABEL (text)

Arguments : text - Required. Text to be converted to the language set in the PowerBI service.

Example : GETLOCALELABEL (‘Bread’)

With PowerBI language set as German. Output will be “Brot”

For more information about localization settings, please click on Learn more about localization settings.

Frequently Asked Questions:

Localization setting in Inforiver is same as Language setting?

Ans. No, Localization setting is to translate the data inside the report visual. Whereas the Language setting is for the Inforiver Menu .

For more information click Localization and Language settings.

Localization is available in Reporting premium?

Ans. Yes, its available in the Reporting premium and Writeback Matrix.

Where can we see the changes after setting Localization in desktop?

Ans. The Localization setting only applies in Power BI Service, depending on the language settings.

Do we need to import or create all the data to translate?

Ans. Yes, we need to implement translations for all the data displayed in the report view.

For new rows or columns, we should use GETLOCALELABEL in the title. For existing data, we simply need to insert GETLOCALELABEL('existing text').