cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JVes
New Member

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

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.

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-zhangti
Community Support
Community Support

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.

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.

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors