Forum Discussion

PowerBirocks's avatar
PowerBirocks
Frequent Visitor
9 years ago
Solved

Change Excel filename or location

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!

 

  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    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

3 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      PowerBirocks
      Frequent Visitor
      9 years ago

      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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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.