KNOWLEDGE BASE
Exporting Data from Cube Data Source
Published: 07 Mar 2013
Last Modified Date: 20 Jul 2023
Question
How to export data from worksheets to Excel from a workbook that uses a cube data source.
Environment
- Tableau Desktop
- Cube data source
Answer
Two options
- Export Summary Data from Published Workbook
- Login to Tableau Server
- Navigate to the desired workbook
- Repeat the following for each desired view
- From the toolbar, click the Export button (first button in the group of four centered buttons above the view)
- Select Data
- If Data is not available, click a sheet within the Dashboard view
- Click Download all rows as a text file
- Export Summary Data from Workbook in Tableau Desktop
- Open the desired workbook
- Repeat following steps for each desired worksheet
- Select Worksheet from the menu bar
- Select Export
- Select Data
Additional Information
- Multidimensional Data Sources cannot export all underlying data
- Each export will only show Summary Data for the given view