PowerBI Data Merging - Recurrently combine Multiple Excel worksheet into a single Workbook

[Anonymous]

Hi,

Has anyone tried to dynamically combine data from multiple Excel Worksheet in a single workbook in a weekly/monthly basis? Tried using PowerBI append for the data but it's not working for me.

Current situation: All Excel files are store in a SP document folder. These files are being uploaded in a weekly/monthly basis. It has different filename but has the same structure.

Any help is appreciated. Thanks!

[Icey · Accepted solution]

Hi @Anonymous ,

Try to Combine files (binaries) in Power BI Desktop.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711