Dienstag, 5. Juli 2011 16:42
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?
Freitag, 8. Juli 2011 18:47
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.
Donnerstag, 5. April 2012 12:59
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?
Donnerstag, 5. April 2012 13:04
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.
- Als Antwort vorgeschlagen MAKSignin Montag, 9. April 2012 12:50
Montag, 9. April 2012 12:51
Thank you Javier