cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
giovi2008 Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Import "SQL Server Synonyms" in the data model

Hi @giovi2008,

 

Based on test, current you can only use advanced t-sql query to get data from synonyms table, it is impossible to direct use navigate to get data.

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
4 REPLIES 4
Community Support Team
Community Support Team

Re: Import "SQL Server Synonyms" in the data model

HI @giovi2008,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
giovi2008 Regular Visitor
Regular Visitor

Re: Import "SQL Server Synonyms" in the data model

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 synonymCapture.PNG

Community Support Team
Community Support Team

Re: Import "SQL Server Synonyms" in the data model

Hi @giovi2008,

 

Based on test, current you can only use advanced t-sql query to get data from synonyms table, it is impossible to direct use navigate to get data.

 

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Re: Import "SQL Server Synonyms" in the data model

Hi @v-shex-msft , has any progress been made on enabling this? "It doesn't do it" really isn't a solution.

 

It's very frustrating that every BI tool for the last 20 years has been able to hit synonyms, but Power BI seems unable to do it when connecting to Microsoft's own database. This isn't rocket science - it just needs to see the synonyms, and then write queries against them using exactly the same SQL as if it were a table or view.

 

I'll open a premier ticket to try to get this addressed.

 

Thanks,

Scott

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 254 members 2,855 guests
Please welcome our newest community members: