Hi, I'm trying to log in to retrieve Google Analytics data from BIGQUERYBut 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?
Go to Solution.
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.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.