Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Synonyms to a tabular model

Hi guys,

 

Please how do I add synonyms to a SSAS 2016 tabular model to use with Q&A in PowerBI?

 

Thanks

2 ACCEPTED SOLUTIONS

I don't believe it is possible. The synonyms are set In The data modelling for Power BI which doesn't happen when you use SSAS tabular direct query. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

v-ljerr-msft
Employee
Employee

Hi @Anonymous,

 

If you're using live connection to your SSAS 2016 tabular model with Power BI, then it is not possible to use synonyms feature in this scenario as Matt mentioned above.

 

However, if you're connecting to your SSAS 2016 tabular mode with Import model, then you should be able to access synonyms in the Relationship view by selecting Modeling > Synonyms.Smiley Happy

 

Regards

View solution in original post

5 REPLIES 5
thesqlgeek
New Member

I have customers who have done this with Language files in SSAS Direct connection.

 

https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/translations-in-tabular-models...

Could you please elaborate more on how this can be achieved? Any videos or links which explains how the synonyms in the Power BI can be customized for SSAS tabular model data source?
v-ljerr-msft
Employee
Employee

Hi @Anonymous,

 

If you're using live connection to your SSAS 2016 tabular model with Power BI, then it is not possible to use synonyms feature in this scenario as Matt mentioned above.

 

However, if you're connecting to your SSAS 2016 tabular mode with Import model, then you should be able to access synonyms in the Relationship view by selecting Modeling > Synonyms.Smiley Happy

 

Regards

Anonymous
Not applicable

Hi Guys,

 

Please how can I add synonyms to a SSAS 2016 tabular model to use with Q&A in Power BI?

I don't believe it is possible. The synonyms are set In The data modelling for Power BI which doesn't happen when you use SSAS tabular direct query. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.