Forum Discussion
Syncing published Power BI report files using OneDrive
Hi All,
We have a couple of PBI reports being published using OneDrive. Everything was working fine until we changed the dataset owner. Now it looks like the connection is broken somehow:
Dataset owner signed out and back in, but the issue remains, the reports in OneDrive don't get published in PBI Service anymore.
Any idea on how we can fix the connection?
Thank you.
Hi Anonymous ,
Did you put the pbix file directly on OneDrive? How did you change the owner of the dataset, by going to the dataset setting page and clicking the Take Over button or by REST API Datasets - Take Over In Group? It's worth noting that if you change the owner of the dataset, the new owner needs to reconfigure all the information (credentials of all data sources involved, scheduled refreshes, etc.). Please check if the new owner has access to the pbix files that locate on OneDrive and if the account is expired?
Take over dataset
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOverIf all the above information is OK, you can try to delete the corresponding report from Power BI Service. Then re-upload the report file by Get Data and check later if the same error is still reported.
In addition, you can refer to the link below to do a make troubleshooting.
When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in. Because Power BI wasn't able to connect to your OneDrive to synchronize with the file, you’ll need to import your file again.
Power BI: Why my report is not refreshing from OneDrive? Compatibility chart for sources.
Best Regards
3 Replies
Hi Anonymous ,
Did you put the pbix file directly on OneDrive? How did you change the owner of the dataset, by going to the dataset setting page and clicking the Take Over button or by REST API Datasets - Take Over In Group? It's worth noting that if you change the owner of the dataset, the new owner needs to reconfigure all the information (credentials of all data sources involved, scheduled refreshes, etc.). Please check if the new owner has access to the pbix files that locate on OneDrive and if the account is expired?
Take over dataset
POST https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOverIf all the above information is OK, you can try to delete the corresponding report from Power BI Service. Then re-upload the report file by Get Data and check later if the same error is still reported.
In addition, you can refer to the link below to do a make troubleshooting.
When you save your changes to the Power BI Desktop file on OneDrive and you don't see those changes in Power BI within an hour or so, it could be because Power BI can't connect to your OneDrive. Try connecting to the file on OneDrive again. If you’re prompted to sign in, make sure you select Keep me signed in. Because Power BI wasn't able to connect to your OneDrive to synchronize with the file, you’ll need to import your file again.
Power BI: Why my report is not refreshing from OneDrive? Compatibility chart for sources.
Best Regards
Adding this for posterity - not sure if it's exactly the same case but I haven't found this solution anywhere else so thought I would leave it here. Had to get help from Microsoft for this so thought others could benefit.
We use a core semantic model with multiple "thin reports" using that model. Each file is hosted on Sharepoint and has been loaded to the Workspace via the Upload > Sharepoint option. The owner's account that performed this was disconnected for a few days due to other issues, and the files were no longer syncing automatically from Sharepoint into the Workspace.
Once the owner's account was restored, fixing the semantic model was fairly straightforward - in Settings, we toggled the "Automatically refresh..." option (being sure to save/exit when it was checked off and then revisit and toggle back on), and then prompted a manual refresh of the model. This was enough to re-establish the sync going forward.
However, thin reports do not have this same option. Here was the trick: Microsoft support had me open the workspace and then append "&addIsRefreshEnabledSetting=1" (no quotes) to the URL. The workspace appears the same, but under Report options > Settings, the side bar now includes at the bottom the "OneDrive refresh" option shown below. Toggle this off, save, and toggle back on, and the report sync is re-established going forward.
