Partilhar via

Create an Excel Workbook data connection (PerformancePoint Services)

  • Artigo

 

Aplica-se a: SharePoint Server 2010 Enterprise

Tópico modificado em: 2017-01-18

Create an Excel Workbook data connection (import a workbook)

An existing Microsoft Excel file can be imported as an Excel workbook data source in Serviços do PerformancePoint. 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 Serviços do PerformancePoint. In Serviços do PerformancePoint, 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.

Importante

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