Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Important: In Excel for Microsoft 365 and Excel 2021, Power View is removed on October 12, 2021. As an alternative, you can use the interactive visual experience provided by Power BI Desktop, which you can download for free. You can also easily Import Excel workbooks into Power BI Desktop

Say you have a Data Model in an Excel workbook, an Analysis Services tabular model, or a multidimensional model on an SSAS server. You want to use Power View in SharePoint Server 2010 or 2013 to explore and present your data. The format and location of your data source determine how you connect to it. If it’s:

An Excel 2013 workbook in a Power Pivot Gallery

  • Click Create Power View Report..

Note: This is only true when Power Pivot Gallery is displayed in Gallery, Carousel, or Theater view.

An Excel 2013 workbook in a Shared Documents library

You need either:

Note: You also need a connection file for Power Pivot Gallery in standard SharePoint library view.

A tabular model on an SSAS server

You need either:

A multidimensional model on an SSAS server

You need:

Either an RSDS or BISM connection file will work to connect to an Excel Data Model or a tabular model. BISM files were designed specifically for connecting to Excel workbooks and SSAS tabular models. RSDS files can connect to many different data sources, but Power View only supports Microsoft BI Semantic Model for Power View data sources. The advantage of RSDS connection files is that you can specify credentials.

To create RSDS and BISM connection files, you need Add Items permissions for the library where you want to store the connection file on the SharePoint site.

After you create the connection file, SharePoint users can create Power View reports based on the model the connection file links to. Read about creating, saving, and printing Power View in SharePoint reports.

In this article

Create a shared data source (RSDS file)

You can create shared data sources on a SharePoint site with SQL Server 2012 Reporting Services (SSRS) SharePoint mode.

  1. In a SharePoint Server document library, click the Documents tab > New Document >Report Data Source.

    Note: If Report Data Source isn’t on the New Document menu, the report data source content type isn’t enabled. The SharePoint site administrator needs to Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode).

  2. In Name, enter a descriptive name for the RSDS file.

  3. In Data Source Type, select Microsoft BI Semantic Model for Power View.

  4. In Connection String, specify a pointer to the data source and any other settings that are necessary for establishing a connection to the external data source. How you connect to a data model depends on how it is published or deployed. Here are examples for:

  5. An Excel workbook in Shared Documents on a SharePoint site with the SQL Server 2012 SQL Server 2012 Reporting Services (SSRS) add-in—for example:

    Data Source=”http://<SharePointSite>/Shared Documents/MyExcelWorkbook.xlsx”

    Note: In SharePoint 2013, if the report and workbook are in the same farm, then you don’t need the Power Pivot for SharePoint add-in. If they’re in different farms, then you still need the add-in in the farm hosting the workbook.

  6. An Excel workbook in the Power Pivot Gallery on a SharePoint site with SQL Server 2012 Power Pivot for SharePoint and SQL Server 2012 Reporting Services (SSRS) add-ins—for example:

    Data Source=”http://<SharePointSite>/ Power Pivot Gallery/MyExcelWorkbook.xlsx”

  7. A tabular model deployed to a SQL Server 2012 Analysis Services (SSAS) instance on a server—for example:

    Data Source=ServerName\InstanceName; Initial Catalog=TabularModelName

    Note: For a default instance, you can leave out “\InstanceName”.

  8. A multidimensional model on an SSAS server—for example:

    Data Source=ServerName\InstanceName; Initial Catalog=MultidimensionalModelName;cube=’ModelName’

  9. In Credentials, specify how the report server obtains credentials to access the external data source. For Power View, credentials need to be stored or integrated. Read Credential and Connection Information for Report Data Sources.

  10. Click Test Connection to validate the data source configuration.

  11. Click OK to create the shared data source.

Top of Page

Create a BISM connection file

You can create Business Intelligence Semantic Model (BISM) connection files on a SharePoint site configured with the SQL Server 2012 Power Pivot for SharePoint add-in. BISM connection files can connect to Excel workbooks or SSAS tabular models.

Top of Page

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×