Power Query Problems

Fix Excel Power Query Not Detecting Web Tables in Internet Explorer Mode

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

The user needs Excel Power Query to detect and import tables from a website that uses Internet Explorer compatibility mode.

Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
The user is connecting to a website with Power Query's web connector and wants to select its tables in Excel.
Observed behavior
Excel does not recognize many of the website's tables, although Power BI Desktop can detect them.
Before you start

Copy the exact page URL and check whether the desired tables require sign-in or a paid account. Also check whether the site offers an official export or API for the same data.

Solution 1Recommended

Update Excel and retry the current web connector

Use this approach first to check whether an updated connector can identify the tables.

A legacy connector may not interpret compatibility-mode pages or dynamically generated tables in the same way as Power BI Desktop. Updating Excel can improve compatibility, but it does not guarantee that every table will be detected.

1
Update Office

In Excel, select File > Account > Update Options > Update Now, if those options are available.

2
Create a web query

Select Data > Get Data > From Other Sources > From Web, or use From Web directly on the Data tab if shown. Enter the page URL and select OK.

3
Review detected tables

In Navigator, select the available tables to preview them. If the desired table appears, select Transform Data to review it, then select Close & Load.

4
Try example-based extraction

If Navigator offers Add Table Using Examples, select it and enter sample values from the desired table. Review the resulting columns before selecting OK and loading the data.

Update Excel and retry the current web connector
Tables may still be unavailable: If the site generates its tables dynamically or requires unsupported authentication, Excel may not be able to extract them through the web connector.
Free Microsoft Office alternative

Work with exported web data in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files or CSV exports in WPS Spreadsheet for an easy transition, though it does not fix Excel's Power Query web connector.

Open and review CSV data exported from a website or Power BICompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for working with rows and columnsFree and lightweight for everyday office tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why can Power BI detect tables that Excel Power Query misses?

The applications can use different connector versions or rendering capabilities. A compatibility-mode page or a table generated dynamically may therefore appear in Power BI but not in Excel's Navigator.

Where is the From Web command in Excel?

Look under Data > Get Data > From Other Sources > From Web. Some Excel versions show From Web directly on the Data tab.

Can I extract a table if it is missing from Navigator?

If available, select Add Table Using Examples in Navigator and enter sample values from the page. If Excel still cannot extract the table, look for an official export or API.

Will a Power BI export refresh automatically in Excel?

No. A file exported from a Power BI visual is a snapshot. To update it, export the data again and reopen or reimport it in Excel.

How can I check that imported numbers retain enough precision?

In Power Query Editor, inspect the column data types and compare imported values with the source before selecting Close & Load. Formatting in Excel can also affect how many digits are displayed.