Create data connections by using PerformancePoint Services

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

Topic Last Modified: 2017-07-28

Summary: Learn how to create data connections from Dashboard Designer to external data sources.

Data sources defined in PerformancePoint Dashboard Designer are stored in a trusted data connection library on SharePoint Server. A trusted data connection library is a document library that you have determined as safe. It restricts using the data source files, but still lets them be read. Administrators can manage data connections on the server by creating more than one data connection library. If a user updates a data source connection in the document library, the information is shared and updated when a workspace file is opened in Dashboard Designer.

 

Content

SharePoint logo

Create a connection from Dashboard Designer to an Analysis Services data cube by using PerformancePoint Services

Create a PowerPivot data connection

Create a connection from Dashboard Designer to a SharePoint list by using PerformancePoint Services

Create an Excel Services data connection by using PerformancePoint Services

Create a connection from Dashboard Designer to a SQL Server table by using PerformancePoint Services

Create an Excel Workbook data connection by using PerformancePoint Services

Show: