Linked filter dropdown values loading indefinitely

Get Help
1

I have a field filter in a dashboard that should show the distinct values in a column. It is also a linked filter to two other filters on the dashboard (limiting values for the filter in question). Instead of showing a dropdown of possible values, it loads (spinning circle) indefinitely. It's set up as per guidance ('category', discarded cache etc)

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.23+9",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.23",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.23+9",
    "os.name": "Linux",
    "os.version": "5.10.216-204.855.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "bigquery-cloud-sdk",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "14.10"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.7.2"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2024-05-28",
      "tag": "v1.49.13",
      "hash": "de28e83"
    },
    "settings": {
      "report-timezone": "Europe/London"
    }
  }
}
2

I should add it loads immediately if the linked filters aren't set to anything

3

if a filter is linked filter then metabase will generate a list of values specifically for that linked combination. So that spinning is actually the query getting sent to your database. At some point it shoudl return those values and cache them.

What version of metabase are you running?

4

We are also having a similar issue in that the linked filter means the dropdown stays empty... however, when you search for something that should be in there, it returns a record. But no matter how long you leave it, the dropdown never populates