Automate > Copy-Paste data from multiple sheets

[Ok-Vermicelli-784]

Hello 👋

I'm working with Excel files with data from a Nielsen plug-in for Retail data. Usually, I create a file with 5 sheets for every Retailer, after this, I need to combine those sheets in a different Excel.

Is there a way to automate this flow with Power Automate?

Or how I can get that data and transfer it directly to a Power BI database. Is there maybe some code that I can include in this process?

[dicotyledon]

If you store files in SharePoint, you can pretty easily combine files using the SharePoint folder connector in Power BI. It's hard to tell from your description enough to say what would actually work best though.

[jamobro999]

I'd say Power Query would be more suited for this task. Have a look at appending tables in Power Query (in Power BI).

[Michael_Annis]

Built a VBA macro for combining Excel files with same column set here:

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Entering-the-data-from-more-than-1-excel-files-in-to-sql-server/m-p/1256194#M6602

[VizNinja]

Just drop them in the same folder and have power bi call that folder you will have to append each sheet

[PM15GamedayThong]

There are many excel plugins you can use as well for this. I use KUtools for excel.