Fix Excel Power Query Not Detecting Web Tables in Internet Explorer Mode
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.
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.
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.
In Excel, select File > Account > Update Options > Update Now, if those options are available.
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.
In Navigator, select the available tables to preview them. If the desired table appears, select Transform Data to review it, then select Close & Load.
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.

Import an official export or API response into Excel
Use the site's export or API when its web page does not expose the tables to Excel.
Export the detected data from Power BI Desktop to Excel
Use this workaround when Power BI Desktop can retrieve the desired tables but Excel cannot.
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.

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.




