Skip to main content

Translating analytics

Translate screen

The Translate screen allows you to translate resource names, captions, descriptions, titles (rich text), custom formula and calculation names and other entries in resources. This screen makes it easy to translate directly within the Data Hub user interface.


This feature replaces the API calls which allowed text in resources to be exported for translation and then later imported.

You access the screen by first determining which resources you want to translate, and then performing one of the following options:

  • To translate all available strings in all of your resources, do not select anything - resources or folders.

  • Select a single resource or multiple resources.

  • Select a folder to translate all of the resources within the folder.

In the following example, two resources and a subfolder have been selected.

Once you've made your selection, click Translate on the FOLDER ribbon. The Translate tab appears, showing all translatable strings in the selected items.

Each language appears in a column, with a vertical ellipsis menu button at the right of the column heading. Additional languages may be added to the screen. Translations may be manually entered or copied between language columns.

An Auto-translate option (using the Microsoft Azure text translation API) is available. You must enter a value for the Microsoft Translator Text API Key in the Miscellaneous section of the Application Settings screen (accessed from the Settings (cog) icon) to enable this feature.

If you prefer, you may export the translatable items as an XML file, translate them externally in Excel or another product, then import the completed XML file.

Once you have completed the translations, save the Translate screen. This updates the translations for each item in the list in whichever resource hosts the item. For non-data model resources, the translations are available immediately. Data model translations are not available until the cube is processed.

To see the translations, switch languages. If the language is supported for the Data Hub user interface, you can select it by clicking the Settings (cog) icon, selecting My Profile, and changing the Localization Language setting. If the language is not listed in the Localization Language drop down list, change your web browser's language using its settings screen (some browsers may require you to change the Windows language instead).

The process of extracting translatable text from resources has been improved:

  • Fewer duplicated entries appear on the Translate screen.

  • Only text that report designers and consumers interact with is extracted.

  • Data models are now supported.


  • Translations are stored in the cube, so they are available even if Data Hub isn't used for reporting.

  • Translations affect only the data model items displayed in the dimension tree; data model items in the Model and Pipeline screens are not translated.

  • The data warehouse is not translated.