none
Tables - Modify Multiple Connections in PowerPivot

    Question

  • Hi,

    Due to some legacy reasons, I have different tables which have 4 connections to SQL Server in PowerPivot. The 4 connections are actually referring to the same database, so how can I modify the connections so my tables refer to the same database and I can delete the 3 redundant connections.

    Thanks

    Friday, February 07, 2014 1:22 AM

Answers

  • I dont think thats possible for Power Pivot 

    it may work via VBA in Excel 2013, but thats just a guess and would need some investigation
    and you would be faster by simply recreating the model


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Monday, February 10, 2014 8:25 AM
    Answerer

All replies

  • when adding new tables, instead of using "From Database" simply use "Existing Connections"
    select your existing database connection and click "Open" to add additional tables from the same database using the same connection

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Friday, February 07, 2014 9:23 AM
    Answerer
  • Yes, I understand this and this is for new project, I don't want to restart from the beginning.

    Is there a simpler way to reallocate connections from a table to a specific database? When you go to table properties, you can change the source name but not the connection name.

    Friday, February 07, 2014 11:23 PM
  • I dont think thats possible for Power Pivot 

    it may work via VBA in Excel 2013, but thats just a guess and would need some investigation
    and you would be faster by simply recreating the model


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Monday, February 10, 2014 8:25 AM
    Answerer