BiqQuery Connection and Extract

[Anonymous]

Hi, I'm trying to log in to retrieve Google Analytics data from BIGQUERY
But in retrieval, I get a separate table for each day

Is there a way to automatically UNION tables in Power Query every time a new table is assembled?

[AlB · Accepted solution]

@Anonymous 

You can probably use #shared to see the tables (queries) and get the names of those you want to do a union (Table.Combine) on

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers