Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

BiqQuery Connection and Extract

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?

 

Need Help
  • AlB's avatar
    AlB
    5 years ago

    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 

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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