Forum Discussion
Import "SQL Server Synonyms" in the data model
We use SQL server synonyms to refer to views in order to decouple view versions from the query layer.
These SQL Server synonyms do not show up in the editor to add data. The synonyms are named dbo.[nameofthesynonym]
As a workaround I added the view and afterwards tried to refer to the synonym via the advanced editor via edit queries but it did not help.
5 Replies
HI Anonymous,
I don't think you can import sql server synonyms relationship model to power bi. If you meant import synonyms tables to power bi, that is possible.
Power bi has its synonyms feature but it only works for Q&A features, I don't think it means you can use synonyms on relationship and data mode analysis.
Power BI Synonyms, Take Q&A Experience to the Next Level
Regards,
Xiaoxin Sheng
Hi Thank you for your reply.
I want to import Synonym tables, so in SQL Server you have the option to create synonyms which are views or tables and can be placed under another name in the schema. We use it for our data layer for instance to create a synonym upon another databases table or view and fetch the replicated table/view in a synonym