Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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.
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |