Query looking at a variable data source where the number of columns change

Question

Basically the number of columns in my data source for which my query works off increases by 1 column every day.

e.g today there are 2259 columns and tomorrow there will be 2260 columns (in my data source)

When I update my data source and refresh the query it creates an error where the last column cannot be found (see below) so I have to manually tell the query that there are 2260 columns in my data source when I'm sure there is a way this can be done automatically.

Also, there are some sheets where I only need the first 100 columns for example. Does anyone know a way where I can make the query display only the first 100 columns and ignore the remaining columns, even if the number of columns increases by 1 each subsequent day?

Any help would be greatly appreciated :)

Answer 1

Power Query is no longer supported here on Q&A. Please post your question over on https://aka.ms/PQCommunity instead.