Forum Discussion
Solved
How to create multiple tables automatically
Hi Experts, I need to create more than 700 queries each one with its respective hyperlink, specific querie name and same script for all. This is what I have done: 1 - In Power Query, new so...
Probably not. But it's worth trying.
What I would do is have a reference table with the list of Google Sheets URLs, and then create a custom Power Query function that pulls the data for each Google sheet from the list. Then simply combine the resulting binaries which gives you the UNION ALL for free. Don't even think of trying to do a UNION.
