Multi-lingual reporting with locale type translation

Hello,

Many business intelligence reporting solutions allows the tool to use a concept of "locale" whereas depending on the choice of language of the user (locale), the description of a field will be returned in the language requested.  This is done at the time of connexion to a data warehouse to return results.

As an example, if we have english (en) and french (fr) and we have a field called gender.  We would have gender_en and gender_fr for english and french descriptions in our source database.  We would create a field called gender_desc with a condition of the type: if locale = en then return gender_en; else if locale = fr then return gender_fr.

We are looking at connecting directly to an Azure datawarehouse to get data for our Power BI reports (direct query); not the import function.

Has anybody worked on something similar?  I heard that Premium might have something; is that the case?  Should I check on Azure related forums for a datawarehouse or semantic related approach?

Any help would be greatly appreciated, thanks!