Meta data translations - Dynamic

[tobny76]

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 model again to the service when business want changes of the translations.

Now we have got a question from the business that they would like to change metadata translations for a semantic model more dynamic as we do for report label translations. 

Today they translate to 15 languages and we have all translations stored in a database and during the refresh every day the report labels can be updated.

Is their a way get the metatranslations to be updated from a database table without republishing the model to the service via scripts or something? 

[v-echaithra]

Hi @tobny76 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @tobny76 ,

Just following up to see if the Response provided was helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

Best regards,
Chaithra E.

[v-echaithra]

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.

[GeraldGEmerick · Accepted solution]

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