I have replayed this lesson and I am clearly misunderstanding something as everytime I follow the steps to add the date table to the data model it adds it to one of it's own instead of the data model that has the 2 tables imported from access. Once I imported the access tables I saved the spreadsheet and then clicked back onto the excel sheet one and 
I just went ahead and opened the spreadsheet with the dates and converted to a table and then clicked add to data model (I am using 2016). What the heck an I doing wrong it's driving me nuts!
I'm still trying to solve this and had a thought - does the linked table have to be a sheet in the same workbook? What I did was create a new workbook and imported the access file as per the tutorial then I opened the dates workbook and tried to link. When I open the sample files the dates table is in the same workbook so is that my problem that a linked table cannot be in a separate workbook?
Hi Gayle,
A linked table will only be linkable to the Power Pivot model in the workbook in which the table resides. So you can either move your dates table to the workbook which contains your Power Pivot model, or use the 'From Other Sources' menu in the Power Pivot window to connect to the Excel workbook containing the dates table.
Mynda
