We’re encountering the [nQSError: 60008] "’Exceeded the maximum query governing rows 2000000 from the database " error while trying to retrieve data for a specific period. Even when reducing the period to 1 day, 1 hour, or 1 minute, we still receive the same error. We’ve observed this issue in two scenarios:
Case 1:
The data volume for the query is around 23–25 Lakh records, according to the queries. It’s a simple pivot query. We’ve applied all possible filters to reduce the data volume and optimised it to the maximum extent on our end. We’re running the report to retrieve just a day's worth of data, which shouldn't trigger the above error, as the data volume is much lower than the 2,000,000 row limit.
Case 2:
There are two tables, T1 and T2, in the Dataset. Table T1 contains almost 20 million records. After applying a left outer join on the ID column, the data is limited to 189,000 rows. When attempting to create a bar chart with this data, we encounter the same error. We tried reducing the report time period to just 1 day, but the above error persists. Even when adjusting the period to 1 hour or 1 minute, the error remains.
Has anyone else experienced this issue? Any known workarounds available?
