topic Re: Merge 2 excel files in Power Query

Merge 2 excel files

Anonymous — Sat, 01 Jul 2023 10:35:54 GMT

Hi All,

Just checking here if some one has video or could guide me how to merge latest created file and latest updated file dynamically in power query?

Re: Merge 2 excel files

Attaluri — Sat, 01 Jul 2023 18:38:11 GMT

Hi,

There are multiple ways to do this.

1. If both files are available in same folder. You can import both files mentioning source as folder path.
2. If both files are different folder. You can import both files seperately and use Append queries feature in Power BI desktop.

Please do let me know incase of any questions.

Regards,

Srini

js.attaluri@gmail.com

Re: Merge 2 excel files

Anonymous — Sat, 01 Jul 2023 21:06:10 GMT

Hello Srini,

Would that work if we have multiple excel files and every week if I add new file and dynamically power query should pick new file as new created and file which was new a week before should be then latest updated? Please note that newly created excel file will be worked on daily basis after power query run.

Re: Merge 2 excel files

Attaluri — Sun, 02 Jul 2023 04:50:26 GMT

Yes, Power Query can pick up all files available in source folder

Based on time stamp of the file using power query or DAX we can create flag/columns to differentiate old and new files.

Do let me know if you have further questions.

Regards,

Srini
js.attaluri@gmail.com