Can queries be made in bulk?

[Monsignor]

Suppose I have 30 tables to append in Power Query. Does there have to be 30 separate queries made, or is there a way to make 30 queries all at once?

 

[Monsignor]

Sure. Here is an example file.

 

[Monsignor]

I just noticed that another way to make a heap of queries quickly is in the Navigator pane "select multiple items."
This would make all the queries even if they aren't going to be combined with each other.

 

[anvg]

Hi
My query uses tables which
1. have table name which starts "Name" (TableNameStartsWith variable).
2. have a column with Name which starts "Names" (ColumnNameStartsWith variable).
For example tables OherTable and Names5 were skipped.
Zippyshare.com - Names PQ Append.xlsx
Regards,

 

[Monsignor]

Thanks for this. I changed one of the names of the tables to 'People' and it's no longer in the final list. Good. That helps me understand what's going on in your code.