Forum Discussion
Microsoft Exchange - Excel files with multiple tabs
I'm using Microsoft Exchange to insert attachments from emails that come monthly. Within the attachment, there are multiple tabs. I need to filter to the specific tab I want to be combined each month. The tabs are not titled the exact same way (ex. January Usage Report, February Usage Report). Is the only way to combine files automatically to have the tabs named identically each month?
10 Replies
- KNPSuper User
Not necessarily, can you provide two sample files that differ as you've described. Remove/change any sensitive data.
This will make it easier for us to offer a solution.
- AnonymousNot applicable
Hi Soc3 ,
You could refer to the blog to know:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin