Create a Shared Data Source for a Data Model (SSRS)
Please visit the most up-to-date Power View documentation on office.microsoft.com. Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.
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
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:
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
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
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