Combining data from Excel each day

[petermb72]

I get an excel sheet sent to me each day.   I have to manipulate it down to a basic one line table:

Date	Units	Hours Spent
08/16/2022	97	45.6

The excel sheet that comes to me the next day, I need to manipulate it down to units and hours spent and add the date column.  I don't want to replace the data in the sheet that I did this to yesterday, instead I want to have it build a table that looks Like this:

Date	Units	Hours Spent
08/16/2022	97	45.6
08/17/2022	96	41
08/18/2022	99	56

How do I get the excel sheets that come in daily to combine in BI to a new table?  Any help would be great.

[hokeson]

Hi, what about to use power automate? Save the excel file each time to sharepoint folder. in powerbi get data from sharepoint folder and transform data from excel sheets. 

[petermb72]

So you are saying use power automate to combine the excel sheets?  I have never used that tool.  If that is what would work, let me know.

[hokeson · Accepted solution]

powerautomate.microsoft.com helps you to save attachments from incomming emails to sharepoint. combine saved excel files can be done in power bi. 

Save my email attachments to a SharePoint document library | Microsoft Power Automate

Combining Excel Files hosted on a SharePoint folder with Power BI | Microsoft Power BI Blog | Micros...