Remove Rows Limit from Frappe Insights Query

Dear Fellows,

I have create a query in Frappe Insgihts which runs successfully, the rows it fetch are more than 1000, but Insights truncate data after 1000 rows. I have tried setting the rows limit to higher number, but it does not take it into account.

Attached is the screenshot.

any help is appriciated

I got the solution!

There is a setting for Rows Limit in general settings for Insights.