powerpivot new linked tables from separte workbooks into the same power pivot window

[BJaremco]

hi,
i have 3 separate workbooks, each housing a table i'd like to link into power pivot and create a relationship for. But i can't seem to get them all into one power pivot window, how do i do that?

 

[ralliartur]

You have two ways of doing it:

1. Open power pivot window and choose From Other Sources -> Excel file (for the tables outside active workbook)
2. Import them using Power Query - create a query to import data from each table (for load option choose connection only). Then in PP window choose option from other sources - you will find there Power Query data sources.

 

[BJaremco]

Thank you, that worked perfectly!