Edit

Activate the report server file sync feature in SharePoint

  • Article

Applies to: ✅ SQL Server 2016 (13.x) Reporting Services and later ✅ SharePoint ❌ Power BI Report Server

The Reporting Services Report Server File Sync feature utilizes SharePoint event handlers to synchronize the report server catalog with items in document libraries. This feature is beneficial when users frequently upload published report items directly to SharePoint document libraries. If the file Sync feature isn't activated, content still synchronizes but not as frequently.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

The File Sync feature can be activated in SharePoint Site Administration after you install the SQL Server 2016 (13.x) Reporting Services or later (SSRS) Add-in for SharePoint products.

This feature can be manually activated and deactivated per site but not at the site collection level.

Prerequisites

The Reporting Services Add-in for SharePoint must be installed. If the add-in isn't installed, the file sync feature won't be visible in the site feature list.

To verify installation, view the list of installed applications in Microsoft Windows Control Panel. If the Reporting Services Add-in is installed, follow the instructions in this article to activate the report server file sync feature.

To activate or deactivate the Reporting Services file sync feature on a site

  1. From the main page of your site, select the Site Actions menu and select Site Settings.

  2. In the Site Actions, select Manage Site Features.

  3. Find Report Server File Sync in the list.

  4. Select Activate.

Note

To deactivate the Report Server file sync feature, you can use the same procedure but select Deactivate.

Related content

Activate the report server integration features in SharePoint
Install or uninstall the Reporting Services add-in for SharePoint
Install or uninstall the Reporting Services add-in for SharePoint

More questions? Try asking the Reporting Services forum