Export (0) Print
Expand All

Create an Excel Workbook data connection (PerformancePoint Services)

Published: May 12, 2010

Create an Excel Workbook data connection (import a workbook)

An existing Microsoft Excel file can be imported as an Excel workbook data source in PerformancePoint Services. Once the data source is created, an internal copy of the Excel file is used and all modifications to the data are done from the Edit tab in Dashboard Designer. The original Excel file is disconnected and independent from PerformancePoint Services. In PerformancePoint Services, security settings for data sources are stored in each data source. However, when you create a data source to an Excel workbook, a copy is imported and stored within PerformancePoint and is no longer an external data source.

To Create Excel Workbook data connection (import a workbook)

  1. Click the Create tab, and then click Data Source.

  2. In the Category pane of the Select a Data Source Template dialog box, click Tabular List and then click Import from Excel Workbook. Click OK.

  3. In the left navigation pane (workspace browser), type the name of your data source.

  4. In the center pane, click Import.

Important Important:

Microsoft Excel Web App workbooks that use the Click2Run method cannot be used as a data source in PerformancePoint Services.

Video demonstration

To view a demonstration of how to create an Excel Workbook data connection in PerformancePoint Services, watch the following video.

Video: Create an Excel Worksheet data connection

Watch the video | To download a copy of the video, right-click the link, and then click Save Target As.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft