Cannot apply filter to questions in dashboard

1

I have a set of questions (all SQL queries) with a custom variable team = {{team}}. I have then created a dashboard with a filter, and linked that filter to each question. I then add a valid input for which I know each question has data (which I can validate on the question itself) and click “Done.” However, each question shows “There was a problem loading this dashboard.”

Steps to reproduce:

  1. Make a SQL question with a Text variable in the WHERE clause (foo = {{foo}}).
  2. Add that question to a dashboard
  3. Add a Other Category filter to the dashboard
  4. From the dropdown on the question, select foo
  5. Enter valid input into the Category for which there is known to be data
  6. Questions says “There was a problem loading this dashboard”

I’ve looked around at all open questions on discourse but cannot find one that represents the issue I am seeing. I really appreciate any help.

2

Hi @JustinC474
Which version of Metabase?
What database are you querying?

Does the user have permissions to the database/collection? Admin > Permissions

It is very strange that it says “There was a problem loading this dashboard” on the individual cards. It should say something like “There was a problem displaying this chart”. Can you provide a screenshot?

When you see the error, check the log (Admin > Troubleshooting > Logs) for more detailed error. Also check the browser console for errors.