Change Excel filename or location

[PowerBirocks]

Hi! I have an Excel file in OneDrive that connect to PowerBI Service. We use PowerPivot for data model in that Excel file. Everything is working well and now we have a few challenges:

1. I have downloaded that file to my local PC and added more tables and measures, and now I want to use this file for production (instead of the one we have in OneDrive). Question: Can I just overwrite the existing Excel file with the updated one? What will happen to my PowerBI connection and visuals?

2. Can I change the filename of the existing Excel file? What will happend to my PowerBI connection and visuals?

3. What if I change the location of the Excel file to another folder in OneDrive?

Thanks for your help!

[T_PHILIP]

Go to "Query Editor" => "Data Source settings" and change the source location. As long as the column headers remain the same, PowerBI will pick up the new source and refresh the visuals. 

[v-caliao-msft · Accepted solution]

Hi @PowerBirocks,

I have tested it on my local environment, for the excel datasource which stored in onedrive, we cannot overwrite the existing Excel file with the updated one, otherwise, the disahboard won't be refreshed. Similar, we cannot change the file name or change the location of the Excel file to another folder in OneDrive.

Regards,

Chalrie Liao

[PowerBirocks]

Thanks @v-caliao-msft. I have done the same test for a smaller file and the results are the same as yours. It would be nice if we have option to point PowerBI to the new filename/location though!

Best,