Visualization setting make export failed

Get Help
1

Hi, we have meet a problem with csv/excel download on version 0.41.0. When quesion's visualization_settings contain some others setting, we will get empty file when download it. Here how we reproduce it.

  1. create a quesion as you like with sample data set. like:
{"type":"native","native":{"query":"select PRODUCT_ID from ORDERS","template-tags":{}},"database":1}
  1. add some setting to visualization_settings, make it from
{"table.pivot_column":"PRODUCT_ID","graph.dimensions":[null],"graph.metrics":["PRODUCT_ID"]}

to

{"table.columns":[{"name":"_col0","fieldRef":["field","_col0",{"base-type":"type/BigInteger"}],"enabled":true}],"table.pivot_column":"PRODUCT_ID","graph.dimensions":[null],"graph.metrics":["PRODUCT_ID"]}
  1. try to download again, and it's empty

and I confuse about how the visualization_setting been set, it looks like the setting will remain even you change the visualization type.

2

@KEN-LJQ Upgrade to 0.41.4 immediately. There has also been several fixes to exports since 0.41.0, so always try the latest release.

3

@flamber after upgrade to latest version 0.41.4, download this still get empty file

4

Problem may soloved, if we modify the quesion and save it again, the visualization setting go right and download successfully.

5

@KEN-LJQ And if you compare visualization settings before and after, how does that look?

6

yes, I modify the column field name, after that, original setting

"table.columns":[{"name":"_col0","fieldRef":["field","_col0",{"base-type":"type/BigInteger"}],"enabled":true}]

chang to

"table.columns":[{"name":"fid","fieldRef":["field","fid",{"base-type":"type/Integer"}],"enabled":true}]

which is correct, but I still confuse about how the original wrong setting comes from

7

@KEN-LJQ It's been a busy week.
https://github.com/metabase/metabase/issues/19465 - upvote by clicking :+1: on the first post