Export (0) Print
Expand All
3 out of 5 rated this helpful - Rate this topic

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

SQL Server 2012
Important note Important

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.

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
    

Arrow icon used with Back to Top link 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.

Arrow icon used with Back to Top link 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).

Arrow icon used with Back to Top link Back to Top

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.