Renaming Excel File Imported to Power BI

[Aazza]

I have imported an Excel file to Power BI and have been using such to create visuals etc.

The excel file is stored in SharePoint and am wanting to change the name of it. Once I change the name of the excel file in SharePoint I open up Power BI desktop, head over to Power Query Editor and then for each tab in the Power Query I go to source> Search for the file> and select the file so that it matches up. 

The issue I am facing is that, for example the name of the excel file was Test 123 if I changed the name of the excel file to Test 456 when going into source to locate for the newly renamed file it is only showing the previously named file (Test 123) I tested this on a test Dashboard and hadn't faced this issue.

Any suggestions on how to fix this issue would be greatly appreciated.

[amitchandak · Accepted solution]

@Aazza , First of you can use edit datasource and change the location/url file for single file source.

Not sure about the name. But the table name in power bi will remain the same even if you change the source file name when do it by the code change