Dashboard cards which contain a filter at question level gets refreshed even if Dashboard Filter is not linked to the card

[Tony-metabase]

Describe the bug

Seems to be related to #8030.

In this case though cards are getting refreshed when a filter that is not linked to them is changed. Note this happens only for cards that are filtered at question level

Important that the behavior in-app dashboard is also reflected on Public and Embedding, so it doesn't divert in behavior.

To Reproduce

1. Go to Question -> Sample DB -> Orders -> Filter by Total is not Empty

2. Add it to a Dashboard
3. Add any type of Filter but don't link it to anything

4. Change Value of the filter and see question getting refreshed.

NOTE: This doesn't happen for cards that don't have a filter at question level

Expected behavior

Question is not refreshed if no filter is linked to it

Logs

None

Information about your Metabase installation

1.46.6 and master

Severity

Would say major since it's a performance issue and a regression (or a partial fix #8030))

Additional context

No response

[paoliniluis]

This also runs the question, so it's also going to overload the DB without even wanting