Unable to modify limit in Table Chart

[zaheer-srushty]

By default, the Table Chart displays 100 rows. It is not showing the entire row result. If the limit is increased, then anl SQL error is raised.

This gives a SELECT error whereas I was thinking the SQL syntax should be applying the LIMIT keyword.

[nextchamp-saqib]

I can't replicate the issue. The limit is applied correctly. Can you share the chart options that you have set?

[zaheer-srushty]

Here's the chart options

[nextchamp-saqib]

It works for me with the same options, can you try creating a new table chart with the same options and check if you can replicate it again?