Edit

Activate the report server file sync feature in SharePoint

  • Article

Applies to: SQL Server 2016 Reporting Services and later SharePoint Not supported 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 will still be synchronized 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 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 will not 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 topic 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, click the Site Actions menu and click Site Settings.

  2. In the Site Actions click Manage Site Features.

  3. Find Report Server File Sync in the list.

  4. Click Activate.

Note

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

See also

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