Changing the Workbook Connection String in PowerPivot

Question

I recently had to move a PowerPivot report from one terminal server to another. I was able to get the PowerPivot Data Connections up and running without much trouble. When I click Test Connection, it is successful. Part of this involved changing the provider (within PowerPivot) from SQLNCLI10 to SQLNCLI11.

However, the Workbook Connection String does not work. It seems that the workbook is still looking for the SQLNCLI10 provider.

Can someone please explain (or direct me to some documentation) how to update the Workbook Connection String?

score -1 · Answer 1 · edited Jan 12 '16 at 01:17

-1

Look on the Data ribbon, in Connections. This opens the Workbook Connections window, listing the connections. Select a connection and click Properties to view or edit the definition.

edited Jan 12 '16 at 01:17

fixer1234

28,064

answered Jan 11 '16 at 22:09

Mike Honey

2,632

score -1 · Answer 2 · edited Feb 21 '17 at 21:37

-1

After a lot of trial and error, I found that after you have changed the connection string in PowerPivot, you have to go to the Design ribbon, then choose Table Properties, update the preview and then click Save. After that, it's possible to save the new properties.

edited Feb 21 '17 at 21:37

Excellll

12,847

answered Feb 13 '17 at 10:39

Magnus Lander

1

Changing the Workbook Connection String in PowerPivot

2 Answers2