Power Query error when table only has one row

  • I currently have a web query setup that draws data from tables into excel, from multiple pages on a site. Occasionally a page will contain a table that only has one row, and I receive the "column cannot be found" error in these instances, thereby stopping my data query. I then have to determine which page has the single row table and remove it from the query. Is there a way for Power Query to bypass or ignore this error? Ideally the table size shouldn't affect the data coming in, as they are all configured the exact same way.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!