05 Temmuz 2011 Salı 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?
08 Temmuz 2011 Cuma 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.
05 Nisan 2012 Perşembe 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?
05 Nisan 2012 Perşembe 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.
- Yanıt Olarak Öneren MAKSignin 09 Nisan 2012 Pazartesi 12:50
09 Nisan 2012 Pazartesi 12:51
Thank you Javier