Google Analytics to Big Query to Power Bi Data Transformation

It is likely possible to automate and speed up what you are doing, and do it all with a single query (not separate queries/tables for each date). It would be a more advanced query, but you can autogenerate a table of dates in the correct text format, prefix them with "events_", and then add a custom column where it queries the events table for that date, so you can then append them all together (with Table.Combine). If you also create a Datetime column along with your original date as text column, you can also set up incremental refresh so you don't have to reload data you've loaded previously with each refresh.

If you get stuck trying that, @ mention me in a reply with the M code from the Advanced editor for one of your existing queries (removing any sensitive info like keys, etc.).

Pat