Forum Discussion

tobny76's avatar
tobny76
Helper III
9 months ago
Solved

Meta data translations - Dynamic

Hi, As you know Metadata translations (such as table and column names) from Translation Builder are stored in the model. So today our central team needs to update the translations and publish the m...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    9 months ago

    tobny76 Perhaps via the XMLA endpoint or maybe the REST API's?

v-echaithra's avatar
v-echaithra
Community Support
9 months ago

Hi tobny76 ,

Thank you for reaching out to Microsoft community.

Use Power Query to import this translations table from the database into Power BI. This query will be part of the data model and can be refreshed every day during the refresh cycle.

 

let

Translations = Sql.Database("YourDatabaseServer", "YourDatabaseName", [Query="SELECT * FROM TranslationsTable"])

in Translations

 

Once the translations are imported, you can use DAX measures to reference the translation table and dynamically display the translated names in your reports based on the selected language. Once you have the dynamic translated column names via DAX, you can use these measures in your visuals to display the translated names in the report.

Hope this helps.
Thank you.