Multiple connection strings in a PowerPivot data sheet

Question

I have 15 tables in my PP data sheet. Since they were added seperately, I now also have 15 connections, one for each table. I am about to cut the number down to one connection, but then wondered if there are any pros/cons to having seperate connections per table. Has anyone else tested this?

Thanks!

Answer 1

Are all 15 connections actually point to the same database? If so, using only one connection will be more efficient in terms of Data Refresh.

Answer 2

Hi

I'm having the same situation. I imported data to powerpivot using queries by connecting to "Get external data from other sources". each time it asks for connection, now i've many queries pointing to same database. I wanted only one connection, so it will be easy for me to handle it. Can anyone help let me know how to do it?

Thanks

Arun

Answer 3

hi MAKSignin

In order to reuse an existing connection (and avoid creating a new connection every time you want to generate a new query), simply go to the 'design' tab in the PowerPivot window, click on 'existing connections' and double click the connection you need.  This will keep the connections to the minimum necessary.

---

Javier Guillen
http://javierguillen.wordpress.com/

Answer 4

Thank you Javier