Powerpivot - Using SQL Server Synonyms

• Vince Poirier

  SSC Eights!

  Points: 932

  More actions

  June 19, 2014 at 7:56 am

  #292517

  Hello,

  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 ?

  Thanks,

  Vincent

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  June 23, 2014 at 12:59 am

  #1723899

  You could just define new views on top of the other ones.

  (which is not ideal of course)

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP