Appending Files from a folder

Hi Sharmile10 

Download example PBIX file

What data do you want from both files?

Looking at the GA3 file there's a sheet with 5 column headers in green.  Do you want these?  I've assumed so in my example file.

I stored the GA3 and GA4 files in separate folders.  Then used the From Folder connector to load all files in each folder.  That'll give you 2 queries I've named GA3 and GA4.

The GA4 file has some different column names so it's easy to rename these to match the GA3 file.  Then delete any other columns from both the GA3 and GA4 tables.

You can then Append both queries into a new query, giving this

Please note that to get the queries in my file working, you will need to change the Source location in the Sample queries and in the GA3 and GA4 queries to match the folders/locations of your Excel files.

Does this give you what you were after?

Regards

Phil