Forum Discussion
Changed Excel source tab names - how do I sync?
I created a workbook last year that feeds an extensive analysis & dashboard in Power BI. There are 3 tabs within the workbook that all had '2018' in the title. I want to use the workbook going forward regardless of year, so I removed the 2018 in each sheet title.
How do I reconcile this within my queries? All of the sources for each sheet have maintained the 2018 titles, but there is no way to edit them. I've tried to go into Advanced Editor and remove all 2018's, but all that did was throw an Expression.Error. "The key didn't match any rows in the table."
I don't want to remake the dashbaord with a new query as it took weeks to make. I thought I'd be able to just refresh the query and it would automatically pull the new sheet names, but that did not happen. Any help is appreciated!
2 Replies
- v-jiascu-msftMicrosoft Employee
Hi sfink22,
I can do it correctly. Maybe you imported the tables while you renamed the sheet names. Please refer to the snapshot below.
Best Regards,
- v-jiascu-msftMicrosoft Employee