Create a Shared Data Source for a Data Model (SSRS)

In SQL Server 2012 Reporting Services (SSRS), a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, you can create a shared data source of type Microsoft Business Intelligence Semantic Model.

In This Article

Connection String

Credentials

Remarks

Connection String

You can create a connection string to an Analysis Services data model in multiple ways. How you connect to a data model depends on how it is published or deployed:

• Published in a PowerPivot workbook in the PowerPivot Gallery on a SharePoint site that is integrated with SQL Server 2012 Analysis Services (SSAS) and SQL Server 2012 Reporting Services (SSRS). The following example shows a connection string:

  Data Source=http://<SharePointSite>/PowerPivot%20Gallery/MyPowerPivotModel.xlsx
  

• Deployed to an Analysis Services instance on a server. The following example shows a connection string:

  Data Source=AnalysisServicesInstance; Initial Catalog=Tabular Model Name
  

Back to Top

Credentials

To connect to a tabular model deployed on an Analysis Services instance, additional configurations are required to make tabular model data available to SharePoint users. For more information, see Connect to a Tabular Model Database (SSAS).

To connect to a PowerPivot workbook, you can store credentials that provide permissions to access the published model.

For information about credentials, see Specify Credential and Connection Information for Report Data Sources.

Back to Top

Remarks

To create this data source type, you must have permissions to create shared data sources on a SharePoint site that is configured for SQL Server 2012 Analysis Services (SSAS) and SQL Server 2012 Reporting Services (SSRS) in SharePoint mode.

For step by step instructions about creating a data source on a SharePoint site, see Create and Manage Shared Data Sources (Reporting Services in SharePoint Integrated Mode).

For information about other ways to create connections to tabular models, see Connect to a Tabular Model Database (SSAS).

After you create this type of data source, SharePoint users can create Power View reports based on the model. For more information, see Power View (SSRS).

Back to Top

See Also

Tasks

Use PowerPivot Gallery

Concepts

Creating, Saving, Exporting, and Printing Power View Reports

PowerPivot BI Semantic Model Connection (.bism)