Skip to content

publish-a-shared-data-source-to-a-sharepoint-library.md

Latest commit

 

History

History
57 lines (39 loc) · 4.1 KB

publish-a-shared-data-source-to-a-sharepoint-library.md

File metadata and controls

57 lines (39 loc) · 4.1 KB
title Publish a Shared Data Source to a SharePoint Library | Microsoft Docs
description Learn how to publish a shared data source to a report server that is running in SharePoint integrated mode.
ms.date 03/07/2017
ms.prod reporting-services
ms.prod_service reporting-services-native
ms.technology reports
ms.topic conceptual
helpviewer_keywords
data sources [Reporting Services], publishing to a SharePoint library
SharePoint integration [Reporting Services], publishing to a library
publishing reports [Reporting Services], to a SharePoint library
ms.assetid 966ed425-3ce2-4e76-8237-3c1c977954ae
author maggiesMSFT
ms.author maggies

Publish a Shared Data Source to a SharePoint Library

To publish a shared data source to a report server that is running in SharePoint integrated mode, you must set the report project properties in Report Designer. In the project properties, all references to servers, reports, and shared data sources must be fully qualified URLs.

You must have Member or Owner permission on the SharePoint site. For more information, see URL Examples for Published Report Items on a Report Server in SharePoint Mode (SSRS).

To publish a shared data source to a SharePoint site

  1. In [!INCLUDEssBIDevStudioFull], open your existing or new Report Server project.

  2. On the Project menu, click Properties. The <project>Property Pages dialog box opens.

  3. Choose the Configuration you use to publish to a SharePoint site.

  4. If you want to publish the shared data sources in your project and overwrite previously published shared data sources, set OverwriteDataSources to True.

  5. (Optional) For TargetDataSourceFolder, type a URL to a SharePoint library or library folder. For example, https://TestServer/TestSite/Documents/DataSources.

    If you do not specify a value, the TargetReportFolder value is used.

  6. For TargetReportFolder, type a URL to a library or library folder. For example, https://TestServer/TestSite/Documents/Reports.

  7. For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used. For example, https://servername, https://servername/site, or https://servername/site/subsite.

  8. [!INCLUDEclickOK]

  9. In Solution Explorer, right-click the shared data source you want to publish, and click Deploy. The data source is published to the location specified in TargetDataSourceFolder. Deployment errors appear in the Output window.

    [!NOTE]
    After you publish a shared data source to a SharePoint site, the file name extension is changed to .rsds. You can edit and manage a shared data source directly on the SharePoint site. For more information, see Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode).

See Also

Publish a Report to a SharePoint Library
URL Examples for Published Report Items on a Report Server in SharePoint Mode (SSRS)
Project Property Pages Dialog Box
Set Deployment Properties (Reporting Services)
Publishing Reports to a Report Server
Use an Office Data Connection (.odc) with Reports (Reporting Services in SharePoint Integrated Mode)