[ES|QL] Filter by dashboard map bounds filter makes es|ql panel display empty panel

[bhavyarm]

Kibana version: serverless-qa/main

Browser version: chrome version

Original install method (e.g. download page, yum, from source, etc.): from QA

Describe the bug: If user has a "Filter by dashboard map bounds filter" on a dashboard and clicks to add an ES|QL panel - the initial panel display is empty.

esql_empty.mp4

This is filter by dashboard map bounds by the way

[elasticmachine]

Pinging @elastic/kibana-esql (Team:ESQL)

[bhavyarm]

Please note - I did log this on dashboards for filter by dashboard map bounds - #186577

[stratoula]

The query that runs is

POST /_query/async?drop_null_columns
{
  "query": "from logs* | limit 10",
  "locale": "en",
  "filter": {
    "bool": {
      "must": [],
      "filter": [
        {
          "bool": {
            "must": [
              {
                "exists": {
                  "field": "geo.coordinates"
                }
              },
              {
                "geo_bounding_box": {
                  "geo.coordinates": {
                    "top_left": [
                      -120.61818,
                      49.71596
                    ],
                    "bottom_right": [
                      -57.223960000000034,
                      33.58892
                    ]
                  }
                }
              }
            ]
          }
        },
        {
          "range": {
            "@timestamp": {
              "format": "strict_date_optional_time",
              "gte": "2024-06-20T06:00:00.000Z",
              "lte": "2024-06-21T06:02:58.114Z"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  }
}

If you run it in DevTools it returns no data so this is expected.

If you change the index in a compatible with this DSL filter index it will work, as I did here