KNOWLEDGE BASE

Exporting Data from Cube Data Source


Published: 07 Mar 2013
Last Modified Date: 02 Sep 2016

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
  1. 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
  2. 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
Did this article resolve the issue?