Power query web link ?

Isn't this the same question you posted half an hour ago here: https://www.excelforum.com/excel-pro...ata-pull.html?

Not nearly enough detail to help you.

Each web site requires different treatment or custom steps to extract info.

But chances are, that column name change caused error somewhere in your query step. Go into query editor and see at which of the applied steps that error is produced.

Then, add a logic and/or custom function to avoid this error.

Such as using Table.ColumnNames function etc.

Right, so instead of using Column Names, you need to use Column positions.

In order to do that, you'd use Table.ColumnNames() function to obtain list of column names. Then use row index to obtain column name(s).
Then use result as is, or in a variable to replace column names that are are hard coded in the query editor with dynamic name.

Ex:

Please Login or Register  to view this content.