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
chettym1963
Regular Visitor

Check link between Sharepoint and Workspace

I have a report in Sharepoint that is linked to the same report in a workspace.  All changes are made to the report in Sharepoint, and the hope is that it will flow to the report in workspace.

 

I've made some edits to the report in Sharepoint (updating visuals, etc.), which are not flowing through to the report in Workspace.  When I tried to manually publish to the workspace, it wouldn't let me, because it said it was already set up with a cloud refresh, so it seems as if the reports are linked. 

 

Is there any way to check the link in the report, to confirm it is linked to Sharepoint?  Or a reason why the link isn't working? 

 

Chet

1 ACCEPTED SOLUTION

Hi @chettym1963 ,

 

If you upload a PBIX file in SharePoint, then upload a PBIX file from SharePoint in your workspace, and then when you edit and change that PBIX in Desktop and then upload it to SharePoint again (select Replace), the report for the workspace will be updated after about an hour. But this does not apply to saving different versions of a report, as you can only replace old reports to ensure that their UIDs are consistent. If you want to save a different version of a report, you can rename it and save it as another report and publish it to the workspace, and then the initial report always chooses to be replaced with a new version of the report, and then upload the report within the workspace, so that you can have a different version of the report in the workspace and a new version of the report forever.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

3 REPLIES 3
v-tangjie-msft
Community Support
Community Support

Hi @chettym1963 ,

 

According to the documentation, you make changes to the file on SharePoint Online, and after you save the file, the Power BI service also synchronizes with those changes, usually within about an hour.

 

You can find the report in the workspaceGo to the data source settings and see if the data source credentials are correct.

 

Import of sensitivity-labeled .pbix files (both protected and unprotected) stored on SharePoint Online, as well as on-demand and automatic dataset refresh from such files, is supported, with the exception of the following scenarios:

vtangjiemsft_0-1679984963314.png

 

Please refer to the following document for more information.

Data refresh in Power BI - Power BI | Microsoft Learn

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

After working with Microsoft Support, it turns out that the way we are saving the report to Sharepoint matters.  We need to save to the Sharepoint directly in desktop, via Save As, versus uploading the file into Sharepoint.  

 

The issue is that by doing it that way from desktop, we will lose version control, which is important for our business.  Therefore, we will need to manually publish the file to the Workspace, and in a separate step, publish the file to Sharepoint and apply our version control.

Hi @chettym1963 ,

 

If you upload a PBIX file in SharePoint, then upload a PBIX file from SharePoint in your workspace, and then when you edit and change that PBIX in Desktop and then upload it to SharePoint again (select Replace), the report for the workspace will be updated after about an hour. But this does not apply to saving different versions of a report, as you can only replace old reports to ensure that their UIDs are consistent. If you want to save a different version of a report, you can rename it and save it as another report and publish it to the workspace, and then the initial report always chooses to be replaced with a new version of the report, and then upload the report within the workspace, so that you can have a different version of the report in the workspace and a new version of the report forever.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

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