Forum Discussion
Synchronize existing items with OneDrive items
Hi v-sdhruv .
Finally, I've solved it! I did what you mentioned; however, it didn't work for me if you already have the workspace assigned to a specific Deployment Stage. What you need to do is follow the steps you mentioned plus the ones below:
- Unassign workspace from the Deployment Pipeline Stage
- Refresh Deployment Pipeline interface
- Assign the workspace again
Magically it pairs the items so we don't alter existing links and items!
Thanks
Hi julsr ,
Currently, Power BI does not provide a way to automatically "link" or synchronize existing workspace items with files that already exist in OneDrive unless they were originally uploaded/imported from OneDrive. If you simply upload files to OneDrive now, Power BI will treat them as new items, and importing them again will create new reports/datasets with new links in the workspace.
Workarounds:
-
Manual Overwrite: The only way to get the OneDrive sync working is to upload your PBIX files to OneDrive, then open each report in Power BI Desktop, save any recent changes into the OneDrive version, and re-publish from OneDrive. This will overwrite the existing report/dataset in the workspace if you publish with the same name and to the same workspace, but the link to OneDrive will only be active for new uploads via “Get data > OneDrive.”
-
New Workspace Items: If you import the PBIX from OneDrive, it will create a new report/dataset in the workspace (with a new GUID/link).
There’s no way to “retro-link” already published reports/datasets to existing files in OneDrive. You’ll need to choose between overwriting or starting fresh with new links.
Reference: Power BI and OneDrive/SharePoint Integration FAQ (Microsoft Docs, Deployment pipelines and version control
Hi! Thanks for your reply HarishKM rohit1991 .
I followed this approach:
- Download original file from the workspace
- Save the file to the Shared Library in OneDrive
- Import this file from OneDrive to the PowerBI workspace (I thought this could overwrite the original file)
However, with the last step what I get is 2 files exactly with the same name, same content, same size and I didn't overwrite the existing one to keep the same link. What did I do wrong?