Convert Data Sources (Report Builder and SSRS)
Each data source in the Report Data pane is embedded and specific to the report or is shared. In Report Builder, a shared data source points to a published shared data source on a report server or SharePoint site. In Report Designer, a shared data source points to a shared data source in the Shared Data Sources folder in Solution Explorer.
For more information about the differences between embedded and shared data sources, see Embedded and Shared Data Connections or Data Sources (Report Builder and SSRS).
For more information on how to create a shared data source, see Create an Embedded or Shared Data Source (SSRS).
Note
You can create and modify paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.
Report Designer
To convert a data source from embedded to shared
In the Report Data pane, right-click the data source, and then click Convert to Shared Data Source.
Note
If the Report Data pane is not visible, on the View menu, click Report Data. If the pane opens as a floating window, you can dock it. For more information, see Dock the Report Data Pane in Report Designer (SSRS).
In the Report Data pane, the data source icon changes to the shared data source icon. In Solution Explorer, a shared data source with the same name appears under the Shared Data Source folder.
To convert a data source from shared to embedded
In the Report Data pane, right-click the data source, open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.
In the Report Data pane, the data source icon changes to the shared data source icon.
Report Builder
To convert a data source from embedded to shared
In the Report Data pane, right-click the data source to open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.
In the Report Data pane, the data source icon changes to the shared data source icon.
To convert a data source from shared to embedded
In the Report Data pane, right-click the data source, open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.
In the Report Data pane, the data source icon changes to the shared data source icon.
See Also
Manage Report Data Sources
Create data connection strings - Report Builder & SSRS