Forum Discussion
Solved
Excel Tab Name Changes
Hello, I get a new data file (Excel) each week. The file gets saved over last week's report (Same file name). The Excel tab name changes to match the week #. It has the naming covention Week ## (...
Hi,
Follow the steps shown in this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.
You have to change the code everytime when the tab name changed. Please refer the below thread,
https://community.powerbi.com/t5/Power-Query/Changing-Excel-sheet-name-in-Power-Query/m-p/2483242
Thanks,
Arul