How to change file location in One Drive for current dataset in Power Bi Online

[JVes]

I've been using an excel data source, located in One Drive without issue for several months. Recently I discovered an issue with the file so I replaced it with a backup. Power Bi Online no longer refreshes. I cannot figure out how to re-link the dataset to the new file. The data is the exact same and the file name is the same as the old file. Please help.

[v-zhangti · Accepted solution]

Hi, @JVes 

Unlike a dataset refresh during which Power BI imports data from a data source into a dataset, OneDrive refresh synchronizes datasets and reports with their source files. By default, Power BI checks about every hour if a dataset connected to a file on OneDrive or SharePoint Online requires synchronization.

Power BI performs refresh based on an item ID in OneDrive, so be thoughtful when considering updates versus replacement. When you set a OneDrive file as the data source, Power BI references the item ID of the file when it performs the refresh. Consider the following scenario: you have a master file A and a production copy of that file B, and you configure OneDrive refresh for file B. If you then copy file A over file B, the copy operation deletes the old file B and creates a new file B with a different item ID, which breaks OneDrive refresh. To avoid that situation, you can instead upload and replace file B, which keeps its same item ID.

You can also refer to the following documents.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#onedrive-refresh 

https://docs.microsoft.com/power-bi/connect-data/service-excel-workbook-files#where-your-workbook-fi... 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JVes]

Hi v-zhangti.

Thank you for your response. Since I already replace the file with the new one, is there a way to change the ID on the new file to match the old? I spent weeks building reports and really want to avoid starting over.