cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SSAS MD Cube with Translations

 

Hi Guys,

 

I have a Dashboard that use SSAS MD as data source using live connection via enterprise Gateway. On our cube, we have captions in English with translation in French and German.

 

With Power BI Desktop the translation is working, for that I have to change the default Language of Windows and PowerBI Desktop.

When I deploy to PowerBI.com the Report is displayed with the language used during the deployment. But if I refresh the report using the button or by changing the selection the langue is always back to French!! (which is not the default language of my cube!!)

 

Does anyone have encountered the same issue?

How did you handle the multi-language with SSAS?

 

Thanks for your help !

 

 

 

 

 

11 REPLIES 11
Moderator v-sihou-msft
Moderator

Re: SSAS MD Cube with Translations

@salafred


I reproduced your issue. I imported SSAS cube with French translation (Default is English). 


Capture11.PNG


When I deploy it onto power bi service first time, it's still displayed in French.


Capture555.PNG

Once I click "Refresh", it changes back to English again.


Capture44.PNG


We will report this issue internally.


Regards,

Simon Hou

Anonymous
Not applicable

Re: SSAS MD Cube with Translations

Hi @v-sihou-msft

 

Thanks for your reply. Keep us posted!

 

Regards,

kaarel Member
Member

isRe: SSAS MD Cube with Translations

Hi @v-sihou-msft Is it working now or should I not use translations when building my cube?

Yuzuriha_Nekoi New Member
New Member

Re: isRe: SSAS MD Cube with Translations

Did you get any answer? We have the same problem with English - Spanish translations

kaarel Member
Member

Re: isRe: SSAS MD Cube with Translations

No answers so far. Can you open a feature request? It has been over a year since multidimensional support was added and still no translations.

kaarel Member
Member

Re: isRe: SSAS MD Cube with Translations

Any updates?

sanjusanjeet Frequent Visitor
Frequent Visitor

Re: isRe: SSAS MD Cube with Translations

Folks, do we have any update on this? If I broswe the cube (SSAS Tabular- Azure Analysis Services) through SSMS, the translation works, but POWER BI live connection doesn't allow to set the default langugae. 

S19K15 Frequent Visitor
Frequent Visitor

Re: isRe: SSAS MD Cube with Translations

Currently, PowerBI Service shows always English captions even there are translations in other languages.

This is happening when connecting Live on Multidimensional Model on Analysis Services even with Localized Analysis Database and Localized Cube in another default language.

Highlighted
jjuelke
Advisor

Re: isRe: SSAS MD Cube with Translations

exactly same issue here: it's not possible to use translations, neither when published to PowerBI.com nor when published to Power BI Report server, see also here:

https://community.powerbi.com/t5/Report-Server/SSAS-MD-Cube-with-Translations/td-p/373816

 

This is a really BIG BUG which affects in special big enterpises, i really wonder that it is still not fixed after years 😞

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 289 members 2,830 guests
Please welcome our newest community members: