How to change a Table's Connection in Power Pivot
excel, powerpivot, sql-server
Solution
If you want to change a table's connection go to the "Design" ribbon in PowerPivot then select "Existing Connections" then select "PowerPivot Data Connections" which will list all your existing connections. Select the connection you want to modify and click "Edit". You can then chose to reload all the tables from the now changed connection by clicking "Refresh" in the "Existing Connections" window.
Problem
Is there a way I can change the Connection for a particular table in PowerPivot? All things I've researched talk about changing the Connection object itself. But I have 5 tables that refer to a single connection and I only need to change connection data for one of these tables.