Table export froms dashboard do not contain all columns

Get Help
1

When I export the results from a table embedded in a dashboard, only the visible columns are present in the exported excel file, the rest of the columns are missing. Not sure if I should be filing this as a bug, or some configuration issue on my end

2

Hi there,

If you hide a column in the visualization settings, it won't appear in the exports. This is expected behavior!
The export should only include the information that you have chosen to display in the question visualization.

3

Sorry, by visible I didn't mean I have hidden the rest of the columns from visualization settings. It's just that the column list is bigger than what can fit on my screen, and the columns which are hidden due to that and are visible after scrolling are not included in the export

4

Could you try reproducing it with the Sample Database? If possible, send the steps taken, and the browser you used for context

5

I have the same issue. Downloading the report's results from the dashboard doesn't include the 2 last columns, but going to the report and downloading it includes them. In my case, I added the 2 columns in question after creating the report. It's as if it only includes the original columns when downloading from the dashboard.

6

Hm, I can't reproduce this in a quick test. What I did:

  1. Created a question on Sample Database/REVIEWS including reviewer and rating columns only with no other processing. Saved it.
  2. Added question to a new dashboard.
  3. Downloaded results from the card using the 3-dots menu/Download results, as csv, verified the 2 columns were present in the csv.
  4. Clicked the title of the card to edit the question.
  5. Added Created At column in the Editor. Saved the question under the same name.
  6. Opened the dashboard and downloaded results from the card again, verified all 3 columns were present in the csv.

Is the card being treated as a visualization as opposed to a question (does the 3-dots menu say "Edit visualization" or "Edit question")?

What format are you downloading the results as?

And as always, what version of Metabase?

7

Thank you for helping.

The card is treated as a question: The 3-dot menu says "Edit question"
Downloading as csv
Metabase 0.55.4

8

I tested on Metabase 0.55.8.6, for the record.

You might try replacing the question with itself to see if that updates things in the dashboard. This usually fixes issues for me where a question and its dashboard card are out of sync.

9

Thanks for the suggestion. I replaced the question and it works as expected now.