Forum Discussion
OneDrive Power BI sync is not working and OneDrive refresh option gets disabled automatically
Hi SparshiJain ,
The problem you are facing is likely related to the fact, that original dataset in your OneDrive tenant was deleted/replaced. Even if the name is the same, the file ID is different and then the connection between OneDrive and PBI Service is lost.
If this is your case, you can try to look in to your bin and restore the deleted version. I am not 100% sure if the file ID will be the same, but it worth trying. Then go to PBI Service - Schedule refresh with OneDrive. Check if you can turn on the sync. with onedrive and test your dataset.
If this won't help I am affraid you need to create a new report with new url.
Let me know,
Migasuke.
This option is getting disabled automatically. I receive below email but no error is mentioned. There's no way I can identify to fix the issue (if any). It's very frustrating as I had spent hours to fix it but nothing worked.
This is the email I get.
Hi SparshiJain ,
The problem you are facing is likely related to the fact, that original dataset in your OneDrive tenant was deleted/replaced. Even if the name is the same, the file ID is different and then the connection between OneDrive and PBI Service is lost.
If this is your case, you can try to look in to your bin and restore the deleted version. I am not 100% sure if the file ID will be the same, but it worth trying. Then go to PBI Service - Schedule refresh with OneDrive. Check if you can turn on the sync. with onedrive and test your dataset.
If this won't help I am affraid you need to create a new report with new url.
Let me know,
Migasuke.Thanks Migasuke . It worked now after I restored the file from OneDrive recycle bin. This also gives me the root cause of when onedrive refresh is disabled automatically for few files while it works for others.
Thanks again.
Sparshi
Hi Migasuke ,
Could you elaborate on a replacement of the original file in OneDrive? My understanding is that once the pbix is uploaded to PBI Service, all changes done to the pbix should be reflected in the PBI Service (with Automated update option enabled). Why do you suggest to restore the original file in order to reactivate the connection?
Recently, I've got plenty of previously uploaded pbixs that I had been able to change over months, but now I see an error "We are unable to locate the file on OneDrive for Business. Please check that the file exists in this location." The files do exist and other models based on pbix files in the same location has no issue.It might be a good idea to consider switching from sharepoint connection to desktop if you keep getting this issue. Here's a video explaining how to do that. And you don't have to share a new link with the users as long as they have access to the new data model, they will be able to keep their bookmarks too.
