Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

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

MattAllington
9 years ago
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.
v-ljerr-msft
9 years ago
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.:smileyhappy:

Regards

5 Replies

thesqlgeek
New Member
9 years ago
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-analysis-services
- Benv117
  Frequent Visitor
  8 years ago
  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?
Anonymous
Not applicable
9 years ago
Hi Guys,

Please how can I add synonyms to a SSAS 2016 tabular model to use with Q&A in Power BI?
- MattAllington
  Community Champion
  9 years ago
  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.
v-ljerr-msft
Microsoft Employee
9 years ago
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.:smileyhappy:

Regards