Dashboard subscription for auto generated dashboards is broken

[perivamsi]

Describe the bug

When you email a dashboard that is auto generated (using xrays), it does not work and you see "an error has occurred while displaying this card" for many of the cards.

Example dashboard where this fails: https://stats.metabase.com/dashboard/2241-a-look-at-accounts

To Reproduce

1. Go to browse data > databases > sample database
2. Click on "x-ray this table" for any table, say Accounts
3. Save the generated dashboard
4. Go to subscriptions > email > and email it to yourself.

Expected behavior

No response

Logs

No response

Information about your Metabase installation

stats

Severity

P2

Additional context

No response

[markbastian]

This ns will reproduce the issue:

(ns tickets.38350-broken-xray-export
  (:require
    [dev.render-png :as render-png]
    [metabase.models :refer [Card]]
    [metabase.test :as mt]
    [toucan2.core :as t2]))

;; Local state

;; Broken
(t2/select-one :model/Card 86)

;; Not broken
(t2/select-one :model/Card 92)

(let [{bad-dataset-query :dataset_query} (t2/select-one :model/Card 101)
      {good-dataset-query :dataset_query} (t2/select-one :model/Card 104)]
  [bad-dataset-query
   good-dataset-query])

(render-png/render-card-to-png 101)
(render-png/render-card-to-png 104)

;; Reproducible case
(mt/dataset test-data
  (mt/with-temp [Card {good-card-id :id}
                 {:display :row
                  :dataset_query {:database (mt/id)
                                  :type     :query
                                  :query    {:source-table (mt/id :orders)
                                             :aggregation  [[:count]]
                                             :breakout     [[:field
                                                             (mt/id :products :category)
                                                             {:source-field (mt/id :orders :product_id)}]]}}
                  :visualization_settings {:graph.series_labels [nil]
                                           :graph.dimensions [{:ProductCategoryMedium {}}]
                                           :graph.colors ["#EF8C8C"]
                                           :graph.metrics [nil]}}
                 Card {bad-card-id :id}
                 {:display :row
                  :dataset_query {:database (mt/id)
                                  :type     :query
                                  :query    {:source-table (mt/id :orders)
                                             :aggregation  [[:count]]
                                             :breakout     [[:field
                                                             (mt/id :products :category)
                                                             {:base-type :type/Text
                                                              :source-field (mt/id :orders :product_id)}]]}}
                  :visualization_settings {:graph.dimensions ["CATEGORY"]
                                           :graph.metrics ["count"]}}]
    (render-png/render-card-to-png good-card-id)
    (render-png/render-card-to-png bad-card-id)))

For a :row chart, the :graph.metrics and :graph.dimensions must be set correctly for static viz. The [{:ProductCategoryMedium {}}] looks like an issue from the x-ray code and the nil metric must be set to the correct value for a :row chart.