Forum Discussion
Understanding sync of changes between Service and Desktop
- 6 years ago
Hi Anonymous ,
After you publish a report to the Service, anything on the Service does NOT come back automatically to the PBI Desktop file.
It is possible that if somebody has the right permissions that they download the file to their desktop, make changes and then overwrite your file by publishing it again. This can happen in a shared workspace, based on permissions. This is not a common thing but can happen.
As for the new visual - if they have save a copy/version of the dashboard for themselves, then it will stay for sure. If they have permissions to modify the shared visual, then it should stay as well. There are now permissions where the other user can use the data to create totally different and new visuals that remain. Again, this is based on permissions as to WHAT they can do and whether or not they make copies or are using the "original" version.
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Hi collinq,
How about the other way round?
I am editing a file in Power BI Desktop which has, as datasource, a spreadhseet in Excel stored in a SharePoint. When changes are made to the spreadhseet and I refresh in Desktop those changes are applied. However, they are not automatically applied to Service. In order for those changes to appear I need to re-publish the PBi which I believe is basically an overwrite of what exists already.
Is there any way of publishing automatically or making sure that when refresh is amde in Service it actually picks up the necessary changes?
Thanks
Hi Anonymous ,
The data source change (in this case Sharepoint document) is reflected in the Desktop and/or the Service whenever it is refreshed. You do NOT have to open Desktop and refresh it and publish it every time since you can have the Service automatically refresh on a schedule. As Anonymous states, you can set up the gateway or the refresh based upon the type of SharePoint that you are using.