Static/Public embeds fail to load dashboard when one of the cards fails to load due to missing filter value.

[Tony-metabase]

Describe the bug

Static/Public embeds fail to load dashboard when one of the cards fails to load due to missing filter value.

To Reproduce

1. Go to New -> SQL Query -> Select * from products Where category = {{something}} -> Save

2. Add it to a Dashboard -> Add a filter to the card:

3. Go to Edit -> Click on the Card and edit visualisation option -> Enable Hide this card if there are no results

4. Go to Share -> Enable Public Sharing (this also happens for Static Embedding) -> Go to the public URL and notice a blank screen:

The dashboard is able to load at first but if you notice the network calls when the error due to filter not being selected for the card occurs it simply breaks the screen:

Something similar to Metabase should occur like the following:

Even though the error message something is gone wrong is very misleading instead of a please select filter for something

Expected behavior

Cannot share an image here but i described it in the Reproduce Section

Logs

None that are relevant even though the actual error is:

Cannot run the query: missing required parameters: #{\"something\"}

Even though it's not specific to that error but how the frontend behaves due to that error

Information about your Metabase installation

1.47.5 ann master

Severity

This completely blocks the usage of 2 important features

Additional context

The only workaround is to put a default value but if you decide to remove it from the URL then you end up breaking the visual again

[albertoperdomo]

@cdeweyx Is this for Dashviz team or for us?

[cdeweyx]

@cdeweyx Is this for Dashviz team or for us?

@albertoperdomo looks embedding-specific so my thinking is #team-embedding

[WiNloSt]

This could either be fixed on FE or BE. The reason is that when query from our dashboard. BE will send data in the response

but not when we're querying from public embed (public link) or static embed

FE fix: Account for the missing data key
BE fix: send data: {rows: [], cols: []} like the dashboard endpoints.