Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PieterHMS
New Member

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

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?

2 ACCEPTED SOLUTIONS
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

ChiragGarg2512
Solution Sage
Solution Sage

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

 

View solution in original post

2 REPLIES 2
ChiragGarg2512
Solution Sage
Solution Sage

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
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors