Language Localization ( Translation) in Azure Analysis Service and Power BI

Localization is very essential to stay competitive and increase the market share in the global market place, it will enable organizations to communicate with their customers around the globe effectively.

Language Localization is the process of translating a product into several other languages and adapting it to a specific country or region.

let's jump into the action …

For this example, I created a sample Model and a Power BI Dashboard as shown below

But there is a huge pressure from Jack, Ma, and William, Li that they want to see the dashboard in their native language ( Chinees). So let's see how we can do this by implementing the Lagungae Localization in Azure Analysis Services and use it in Power BI

Language Localization in Azure Analysis Service

Open your Azure Analysis Service Model in Visual Studio
Go to Model → Translate → Manage Translations

Select the Language that you want to translate to and Click on Export Selected Language.
Choose a folder and save the JSON file

Open the newly saved JSON file in the Visual Studio, the JSON file contains translated captions and translated descriptions

It's time for us to fill the captions and descriptions with the appropriate language that you want to translate. In this example, we are translating it to Chinees.

The translated JSON file is ready, so let's import this file to the Azure Analysis Service Model and see how it works.

Go back to the Model solution and Click on Model → Translate → Import translations

Click import and deploy the solution…wait for the model to deploy

Open the model in either Excel or SSMS for a quick verification ..Hoooray !! the model is now translated to Chinees.

Now its time to update the Power BI dashboard, so let's jump on it

Open the Power BI dashboard and refresh…UGH!!! it's still the same, the dashboard not translated to Chinees

Ok, relax!! In power BI we have to change regional setting s to display the translations..so let's do it…

Open Options and change the Regional Settings to the Language that you translated the model → Click ok and → Close and re-open Power BI

Open the Dashboard and you can see the model in the new translated language

Now Jack, Ma, and Li can analyze the data in their native language. See how joyful they are 😊

Hope you enjoyed reading this article, see you in my next article until then stay safe and explore new things ( project SolarX to explore the Sun😊)