How do I connect a SQL Server synonym to an Excel data model?

I have a SQL Server (12.0.411) database with a view that is referenced by a synonym.

I want to load the data from the view into Excel's data model using the synonym.

In Excel (Microsoft Office Professional Plus 2013) I go Data/Connections/Add to Data Model. The Select Table dialog offers my the views and the synonyms but when I select a synonym I get an error box:

We can't find table "DBName"."dbo"."synonymname".

Is this a known limitation or am I missing something?

If I don't add to the Data Model, but simply put the data into a table in Excel it all woks as expected, so I don't believe the problem is with permissions.

Sorted by: Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy