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