Table in canvas not showing

Elastic Stack Kibana
1

I'm new to canvas so my question might be stupid. I'm trying to add metricbeat data to a table using essql. In the preview data section, I can see my data but the table's empty.
Here's the expression I'm using:

filters
| essql query="SELECT agent.name FROM \"metricbeat-7.10.0-2021.02.13-000001\""
| table
| render containerStyle={containerStyle border="2px groove #000000" borderRadius="2px"}

ELK version: 7.11

2

Do you have any filters added to your canvas board? They may overlay the data you are querying. You should also consider to load the metricbeat Index using a Wildcard pattern like metricbeat-*

Also have a look into some Kibana Canvas examples

3

Yep, That was it. Thank you.