Overview of Excel Services reports displayed in PerformancePoint Web Parts

We are in the process of combining the SharePoint Server 2013 and SharePoint Server 2016 content into a single content set. We appreciate your patience while we reorganize things. See the Applies To tag at the top of each article to find out which version of SharePoint an article applies to.


Applies to: SharePoint Server 2013 Enterprise

Topic Last Modified: 2013-12-18

Summary: Learn about how to display Excel Services reports in Dashboard Designer.

By using PerformancePoint Dashboard Designer, you can include Excel Services reports in your PerformancePoint dashboards. Excel Services reports are Excel workbooks that have been published to SharePoint Server. You can display a single item in the workbook, or the whole workbook in your PerformancePoint dashboard.

When you use Dashboard Designer to include Excel Services reports in your dashboard, you do not actually create the reports. Instead, you create PerformancePoint Web Parts that are designed to display Excel Services reports and receive dashboard filters.

Use Excel Services reports for purposes such as the following:

  • To display view types that you cannot create by using Dashboard Designer. Examples include PivotChart reports, PivotTable reports, and tables that contain conditional formatting or other custom formatting that is not available in analytic grids.

  • To save time by displaying existing reports, instead of creating (or recreating) new Excel workbooks.

  • To include interactive reports in your dashboards that users can either view in a web browser or open in Excel.

  • To create reports that use data source types not available in Dashboard Designer.

These are only some examples of how an Excel Services report can be useful. An Excel Services report displays all or part of an Excel workbook that was published to SharePoint Server 2013 by using Excel Services. You can include Excel Services reports in your dashboard, either as a single item on the page or as an item alongside other dashboard items. In addition, you can connect dashboard filters to Excel Services reports, together with other kinds of PerformancePoint reports and scorecards.

You would typically include one or more Excel Services reports in your dashboard to enable dashboard users to easily view and explore data. Depending on how you set up your reports, dashboard users can perform these kinds of tasks:

  • Browse through pages in Excel workbooks without opening Excel

  • Apply (or change) internal filters for charts and tables that were created in Excel

  • Sort rows or columns in charts or tables

  • Use the Refresh button in the browser window to restore the Excel Services report to its default view

Excel Services reports can use various data sources, such as those in the following list:

  • A SQL Server database

  • A SQL Server Analysis Services data cube

  • A Access database

  • An online analytical processing (OLAP) database

  • A relational database

  • An Excel workbook

  • A text file

  • An external data connection file that is defined as a trusted data provider. Examples might include those in the following list:

    • SQL Server OLE DB, ODBC, or OLAP

    • OLE DB and ODBC for Oracle

    • OLE DB and ODBC for IBM DB2

Data connections are defined in the Excel workbooks and are retained when the workbooks are published to SharePoint Server.