I have a query set up in Access that works as intended. I used Power Pivot in Excel 365 to import a link to the Access query. When I view the data in the Power Query Editor is says I need to refresh the preview every time I go in (56 days old at this point). When I click refresh it will show the missing entries in the table but if I filter on one of the previously missing entries it says 'This table is empty'. I also set up a pivot table within the workbook and it also will not show the missing entries. It is almost like it is only pulling in records that were present when I initially created the link to Access. Ideas on what could be going on?