Forum Discussion
Importing an Excel Spreadsheet where the table name changes.
Hi all, Daily I recieve a spreadsheet which contains 1 sheet and only ever 1 sheet this will not change as it is coming from raw data inside a suppliers system. The sheet is called the date in YY...
Hi Anonymous,
Based on my research and test, you can make some changes for the whole workflow. You can add the sheet of each day into a single Excel Workbook named "Daily Report.xls", then add a parameter of sheet name in Advanced Editor following the instructions in this similar blog . After that, you can import all the data of different days into Power BI Desktop and filter data of specific day to create reports.
Another method is to use VBA code to change the name for the current sheet to a fixed name, for more details, please review this similar article and video.
Thanks,
Lydia Zhang