Source page keeps getting small changes

[Missippy]

I run power queries every morning where I download a lot of data from a webpage. The source keeps making these small changes, like adding a column to the page I am trying to download. When they do, my query won't run any longer. They did this about 4 weeks ago and I just got all the queries up and running again. Now they have added 1 more column. Is there anything I can do to avoid the total rebuild?

[v-pgoloju]

Hi @Missippy,

Thanks for reaching out to the Microsoft Fabric Forum Community.

If you want to ignore newly added columns and only keep specific ones, you can use the following M code.

Table.SelectColumns(Source, {"Col1", "Col2"}, MissingField.Ignore)

This helps avoid errors when the source adds new columns unexpectedly.

However, if you want to load the entire table dynamically, including all columns, you can get the list of all columns using.

AllColumns = Table.ColumnNames(Source)

If the issue still persists, please share the M code you’re using so we can take a closer look and help you resolve it.

Thanks & regards,
Prasanna Kumar

[Missippy]

Thank you for responding. Unfortunately I don't know what m-code is. When building a query, I just select data, from web, paste the link to the web page, choose columns and such, add to page. That's it.