Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Powerpivot - Using SQL Server Synonyms Expand / Collapse
Posted Thursday, June 19, 2014 7:56 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 10:05 AM
Points: 295, Visits: 131

I have about 50 user views that are consumed by customers via PowerPivot.
They want to completely change the naming convention of the views.
To accomplish that, and prevent the failure of previously created Excel PowerPivot extracts, I thought of using SQL Server Synonyms.

To my surprise, it appears that PowerPivot is unable to consume SQL Server Synonyms.
Upon selecting SQL Server Objects, it would just propose "Select Tables and Views", not showing my synonyms.

Can you tell me if it is possible for PowerPivot to consume Synonyms ?
If not, do you have any other suggestion to change a Naming Convention without breaking anything ?


Post #1583837
Posted Monday, June 23, 2014 12:59 AM



Group: General Forum Members
Last Login: 2 days ago @ 2:09 AM
Points: 15,501, Visits: 13,163
You could just define new views on top of the other ones.
(which is not ideal of course)

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1584918
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse