Geek asks and answers

How to change table connectivity in Power Pivot

Is there a way to change the join for a specific table in PowerPivot? All that I examined is about changing the Connection object itself. But I have 5 tables that refer to one join, and I only need to change the join data for one of these tables.

+3
source share
3 answers

If you want to change the connection to the table, go to the Design feed in PowerPivot, then select Existing Connections, then select PowerPivot Data Connections, which lists all existing connections. Select the connection you want to change and click "Change." Then you can reload all tables from an already changed connection by clicking Refresh in the Existing Connections window.

+1
source
  • Delete table (right-click the grid tab and select delete).
  • , " ", . , , " ". .

Paul Te ​​Braak BI blog, , , SQL-.

0

More articles:


All Articles