cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Galat198
Helper III
Helper III

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?

Galat198_0-1607937044439.png

 

1 ACCEPTED SOLUTION
AlB
Super User III
Super User III

@Galat198 

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 

SU18_powerbi_badge

View solution in original post

1 REPLY 1
AlB
Super User III
Super User III

@Galat198 

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 

SU18_powerbi_badge

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors