How to Fix Power Query Cannot Detect a Table on a Website in Excel
Question details
The user is unable to extract or detect a data table from a website using the Power Query web connector.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to import tabular data from a web page using the 'From Web' feature in Excel Power Query.
- Observed behavior
- Power Query fails to display the expected website table in the navigator window because the page is dynamically generated, loads the table after the initial request, or relies on specific URL query parameters.
Open the target website in your browser, right-click the page, and select 'View Page Source' to confirm if the table data exists in the initial HTML or if it requires dynamic JavaScript loading.
Verify URL Parameters and Query Pages Individually
Use this method if the website table is paginated or relies on a specific page number parameter in the URL that Power Query missed during the initial connection.
Many websites use dynamic URLs that require specific query parameters (like '?page=2') to display data. If you provide a base URL without these parameters, Power Query may return a blank page or an empty table.
Open the website in your browser and click on the next page of the table. Look closely at the address bar to see if a page-specific parameter appears at the end of the URL.
In Excel, go to Data > From Web. Paste the exact URL that includes the page parameter directly into the URL dialog box instead of the generic base URL.
Once Power Query detects the table on that specific URL, select the table and click 'Transform Data' to clean the columns before loading it.
If you need data from multiple pages, open the Advanced Editor in Power Query and convert your query into a custom function to automatically loop through the required page numbers.

Extract Underlying API Data via Browser Developer Tools
If the table is dynamically generated by JavaScript and doesn't appear in the HTML source code, you must find and connect to the backend data API.
Manage and Analyze Your Data with WPS Office
If Microsoft Excel's Power Query struggles with your specific web data needs or you are looking for a more accessible spreadsheet tool, WPS Office is an excellent choice. It offers a lightweight, highly compatible spreadsheet application perfect for viewing, editing, and analyzing exported web data without heavy subscription costs.
- 1. Download and Install: Visit the WPS official website and download the free WPS Office suite for your device.
- 2. Open Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to create a new blank workbook or open an existing file.
- 3. Import Your Data: Go to the Data tab to easily import CSV or text files extracted from web sources for seamless analysis.

Frequently Asked Questions
Why does Power Query return an empty table from a website?
This usually happens when the webpage uses JavaScript to load data dynamically after the initial HTML is sent. Power Query's standard web connector only reads the initial HTML source code and cannot execute JavaScript to render the final table.
How can I check if a table is actually in the page source?
Right-click the webpage in your browser and select 'View Page Source'. Press Ctrl+F and search for specific data entries from the table. If they cannot be found, the table is dynamically generated.
Can Power Query scrape tables behind a login screen?
Yes, but typically only if the website supports Basic, Windows, or Organizational authentication. For complex web forms or token-based logins, Power Query may fail, and you may need to use advanced API requests or dedicated web scraping tools.
How do I combine multiple pages of web data into one table?
You need to create a custom parameterized function in Power Query. After establishing a connection to a single page, convert the page number in the URL to a parameter variable, then invoke this function across a generated list of page numbers.




