A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Shruti
May I clarify whether you are referring to a dashboard created using Power Query? If so, you can try the following steps to update the data source:
- Open the dashboard workbook.
- Select Data > Get Data > Data Source Settings.
- Under Data sources in current workbook, select the original spreadsheet source.
- Click Change Source, then browse to and select the renamed file.
- Select Data > Refresh All.
If this is not what you are referring to, I would appreciate it if you could share some additional details so I can better understand the situation and assist you further.
If you have any updates, please feel free to share them.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.