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.
Are you expecting to be able to cram all these queries into the same .pbix file? Or will you create one file per query?
Here's what comes to mind:
- template apps
- REST API
- VBA to autogenerate the Power Query code
- modify the .pbix file directly via Powershell
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.
