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!
