Forum Discussion
How to create multiple tables automatically
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.
Hi lbendlin
I am expecting cram all these queries into same .pbix file. They are google sheets that are updated daily. After importing I intent to use UNION dax . I estimate having a .pbix with about 70mb after connecting all.
Not sure if Power Bi will support that.
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.