The data used to present the dashboard or report currently active in the item viewer can be exported to a Microsoft Excel file (*.xlsx). The exported data is based on the currently displayed view. To update the view of the dashboard or report to reflect the most recent data, click Refresh in the View ribbon group.
For more information on exporting individual dashboard items, see Exporting or Printing Individual Dashboard Items.
To export dashboard or report data to Microsoft Excel:
Data from each data provider is added to a new sheet in the exported spreadsheet. For example, if a dashboard contains data from two data providers, the spreadsheet will contain two sheets, one with the data from each data provider.
The following considerations apply when exporting dashboard or report data to a Microsoft Excel spreadsheet:
-
Special characters in data provider names (for example, "\/*:[]") are replaced with an underbar (_).
-
Data provider names that are longer than 31 characters are truncated at 31 characters.
-
Duplicate data provider names are given system-generated unique names.
-
For any cells containing text, any text that would begin with an equal sign (=), a plus sign (+), a minus sign (-), or a commercial at sign (@), a single space will be added to the beginning of the cell. This is necessary to prevent the values from being executed when the spreadsheet is viewed.
-
For cells that contain only numbers, negative numbers will have a single quotation mark (') added to the beginning of the cell. This is necessary to prevent the values from being executed when the spreadsheet is viewed.
Exporting a report using Export Dataexports all of the available data for the report which requires running the report again to return current data. To export a report using the column selections and groups used in the report, right click on the report and select Export Report to Exceluicontrol> or use the Export Touicontrol> functionality in the Dashboard title.
For reports which execute long running queries, the Export Data feature will refresh the data within the export by running the report again. The cache feature for the Data Provider can be used to provide short term storage of the results and alleviate the running of the report again. For more information, see Changing the Advanced Properties for a Data Provider.