Compare shared and embedded data sources - Report Builder & Reporting Services (SSRS)

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

You can connect to data with either a shared or an embedded data source. A shared data source is defined independent of any report. You can use it in multiple reports on a report server or SharePoint site. An embedded data source is defined in a report. You can only use it in that report.

Shared data sources are useful when you have data sources that you use often. We recommend that you create and use shared data sources as much as possible. They make reports and report access easier to manage, and help to keep reports and the data sources they access more secure. If you need a shared data source, you may need to ask your system administrator to create one for you.

An embedded data source, also known as a report-specific data source, is a data connection that's saved in the report definition. Embedded data source connection information can be used only by the report in which it's embedded. To define and manage embedded data sources, use the Data Source Properties dialog box.

The difference between embedded and shared data sources is in how they are created, stored, and managed.

• In Report Designer, create embedded or shared data sources as part of a SQL Server Data Tools (SSDT) project. You can control whether to use them locally for preview or to deploy them as part of the project to a report server or SharePoint site. You can use custom data extensions that have been installed on your computer and on the report server or SharePoint site where you deploy your reports.

  System administrators can install and configure additional data processing extensions and .NET Framework data providers. For more information, see Data Processing Extensions and .NET Framework Data Providers (SSRS).

  Developers can use the Microsoft.ReportingServices.DataProcessing API to create data processing extensions to support additional types of data sources.

• In Report Builder, browse to a report server or SharePoint site and select shared data sources or create embedded data sources in the report. You can't create a shared data source in Report Builder. You can't use custom data extensions in Report Builder.

Summary of differences

The following table summarizes the differences between embedded and shared data sources.

Description	Embedded Data Source	Shared Data Source
Data connection is embedded in the report definition.
Pointer to the data connection on the report server is embedded in the report definition.
Managed on the report server
Required for shared datasets
Required for components

Next steps

Create and Manage Shared Data Sources
Create and Modify Embedded Data Sources
Set Deployment Properties
Specify Credential and Connection Information for Report Data Sources

More questions? Try asking the Reporting Services forum