PBIX files uploaded from Sharepoint: changes made in PBI service not saved to SP

[PieterHMS]

We are trying to have one version of a .pbix file for a given report by using Sharepoint and OneDrive.

We create the report and dataset in PBI Desktop, then we save/upload the file to Sharepoint. In PBI Service we use Upload from Sharepoint to get this report in our workspace. Right after I do that, I see the little halo/rays next to the report name in the PBI workspace. At this point, when I make a change to the PBIX file using PBI Desktop, it actually updates the report in PBI Service. So far so good.

However, what doesn't work for me is when I make changes in the report in the PBI Service screen, these changes are not saved back to the Sharepoint file. So it seems like a one-way synchronization only.

What am I missing? How is this link between PBI service and Sharepoint supposed to work?

[TomMartens · Accepted solution]

Hey @PieterHMS ,

indeed the synch is oneway - from SharePoint to Power BI Service.

Changes made in the Service will not be saved back to SharePoint.

My recommendation:

1. Upload the pbix to OneDrive
2. Upload the Pbix to the Power BI Service
3. Synch the SharePoint Folder that contains the pbix to your local machine
4. Update the pbix using Power BI Desktopn

When you save the pbix, the automatic SharePoint synch will "copy" the pbix from your local machine to the SharePoint folder. From here the Power BI Service will update the Report, but this may take a while.

Hopefully, this provides what you are looking for.

Regards,

Tom

[ChiragGarg2512 · Accepted solution]

The PBI service is the end point which is connected to the sharepoint only for data displaying/retrieving purposes. When there is a change in PBI desktop the changes are saved in sharepoint and reflected on service. But the file in service is not connected to sharepoint for saving purposes.

If Git integration is used, there is a way to get two-way synchronisation. Refer to this:

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-git

[TomMartens · Accepted solution]

Hey @PieterHMS ,

indeed the synch is oneway - from SharePoint to Power BI Service.

Changes made in the Service will not be saved back to SharePoint.

My recommendation:

1. Upload the pbix to OneDrive
2. Upload the Pbix to the Power BI Service
3. Synch the SharePoint Folder that contains the pbix to your local machine
4. Update the pbix using Power BI Desktopn

When you save the pbix, the automatic SharePoint synch will "copy" the pbix from your local machine to the SharePoint folder. From here the Power BI Service will update the Report, but this may take a while.

Hopefully, this provides what you are looking for.

Regards,

Tom

[jcastiblanco82]

Hello Tom,

I have been using this feature for months, but this year, my reports allocated in the SharePoint library are not automatically updated in Power BI Services. Do you know why?