Hi,

I have a power query set up that combines all of the data from a named table in files stored in a SharePoint folder. When I created the initial query Power Query automatically created some "Helper Queries". In these helper queries there are the following:

Parameter1 (Sample File)

Sample File

Transform File

There is also an additional query called Transform Sample File.

As mentioned the combine query uses these to get the data from a table within the files called "Sales_Table".

What I now want to do in the same file is to combine the data from the same Sharepoint folder, same files, but from a different table. The table is called "Bank_Table".

Is it possible to use the Helper Queries to do this and if so how do I get them to select the "Bank_Table" rather than the "Sales_Table". Is this the best way to achieve what I want to do or is there a better way anyone can suggest?

Thanks in advance.

Bax