SSAS Tabular Translations don't appear on Excel

Question

Hi, i need help on SSAS translations not appearing on Excel. I have a tabular model developed on SSDT, and for some reasons i'm trying a French translation associated to my language pt-PT, so that in my personal VM with portuguese settings i can confirm it works.

What happens is that the translation doesn't work, i have to force the LocaleIdentifier=2070 (for Portugal) on the Excel connection and then it appears with the changes.

Does someone know or have any idea why do i have to force the LocaleIdentifier? Basically, if i don't force this attribute on connection, translations don't work.

I don't know if i'm missing something basic, of if it's something related with the VMs on the organization, because, though my VM has portuguese regional settings, i work for a French company, so maybe there is some French configuration on my Windows that i have to change...

 

(BTW, In PBI Desktop, the same is happening - I can't see the translations associated to my language, and as i'm connected to a SSAS tabular, i can't change the settings in the PBI report file... does someone know can i change them????)

 

Thank you and best regards.

Answer 1

Hi Lrmmf,

This forum(Excel for Developers) is for issues related to Excel and your issue is related to SSAS Tabular Translations, I will move your thread to Where is the Forum For…? so someone could tell you where to go ask your question.

Thanks for understanding.

Best Regards,

Lina

---

MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread.

Answer 2

Something here might help.

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/translations-in-tabular-models-analysis-services?view=sql-server-2017

https://www.sqlbi.com/articles/translations-in-analysis-services-2016/

or also ask for help over here.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices

 

 

---

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.