Power Query Problems

Fix Power Pivot Import of Linked Access Tables in Excel

Elise WilliamsElise Williams Nov 20, 2026 868 views

Question details

Import data from Access tables linked to Excel workbooks into the Excel Data Model.

Fix Power Pivot Import of Linked Access Tables in Excel
Product
Microsoft Excel Power Pivot and Power Query
Device & OS
not provided
Scenario
An Access database contains tables linked to Excel workbooks, and the user wants to use their data in Power Pivot.
Observed behavior
Power Pivot may report that no tables were found when importing the linked tables, even though local Access tables can be imported.
Before you start

Identify the Excel workbooks behind the linked Access tables and make sure you can open them. In Access, check the linked table properties or Linked Table Manager to locate their source files.

Solution 1Recommended

Import the source Excel workbooks through Power Query

Use this workaround when Power Pivot cannot find Access tables linked to Excel files.

Connecting to the source workbooks bypasses the linked tables in Access. Recreate any needed Access transformations or relationships in Power Query or the Data Model.

1
Connect to a source workbook

In Excel, select Data > Get Data > From File > From Workbook, then browse to an Excel file used by a linked Access table.

2
Select the source data

In Navigator, select the relevant sheet or table, then choose Transform Data to open Power Query Editor.

3
Transform or combine data

Use the Power Query Editor commands to clean the data. If you have multiple source files, add queries for them and use Append Queries or Merge Queries as needed.

4
Load to the Data Model

Select Home > Close & Load > Close & Load To. Choose Only Create Connection, select Add this data to the Data Model, and click OK.

5
Check the model

Open Power Pivot > Manage to verify that the imported data appears, and create relationships between tables if needed.

Import the source Excel workbooks through Power Query
Keep source files accessible: The queries depend on the source workbook locations. If a file moves, update its source path in Data > Queries & Connections before refreshing.
Free Microsoft Office alternative

Work with Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to review and edit source data with an easy transition from Microsoft Office. It does not fix Power Pivot or replace this Power Query workflow.

Review and edit spreadsheet source data in WPS SpreadsheetsCompatible with Microsoft Excel formats including XLSX and XLSFamiliar interface makes common spreadsheet tasks easy to findFree and lightweight for everyday document work
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Pivot show no tables in my Access database?

Power Pivot may not recognize Access tables that are linked to Excel workbooks, even when local Access tables are available. Connect to the underlying workbooks through Excel's Data > Get Data menu instead.

How do I load a Power Query result into Power Pivot?

In Power Query Editor, select Home > Close & Load > Close & Load To, then select Add this data to the Data Model. You can check the result under Power Pivot > Manage.

Can I combine data from several linked Excel workbooks?

Yes. Create a Power Query connection for each source workbook, then use Append Queries to stack similar data or Merge Queries to join matching rows.

Will the query update when a source workbook changes?

You can refresh the imported data using Data > Refresh All, provided the source files remain accessible. If a file has moved, update the query's source path first.

Does importing the source workbooks preserve my Access relationships?

Not automatically. After loading the data, check Power Pivot > Manage and recreate any relationships needed in the Data Model.