What is the maximum number of queries to be executed (number of results)?

Naoki
Microsoft Employee
Microsoft Employee

When executing a new query, I received an error message that said "Please delete existing query results.

What is the maximum number of query results (size of result data) that can be stored?

Is this at the tenant level? Is this at the partition level? Is it at the query execution user unit level?

Also, is there a setting to automatically delete past query results?

1 ACCEPTED SOLUTION

Dazza
Valued Contributor II
Valued Contributor II

Hi @Naoki

I believe there is a limit of 20 "auto-refresh" queries that you can have turned on per tenant. To my knowledge, there is no auto-deletion of query results, and I don't think there is a limit to queries which are not set to refresh automatically. 

If you're still having an issue, or if I've misunderstood your question - please share a screenshot of the error, as this might assist in providing a better answer/explanation. 

View solution in original post

2 REPLIES 2

Dazza
Valued Contributor II
Valued Contributor II

Hi @Naoki

I believe there is a limit of 20 "auto-refresh" queries that you can have turned on per tenant. To my knowledge, there is no auto-deletion of query results, and I don't think there is a limit to queries which are not set to refresh automatically. 

If you're still having an issue, or if I've misunderstood your question - please share a screenshot of the error, as this might assist in providing a better answer/explanation. 

Naoki
Microsoft Employee
Microsoft Employee

Thank you, @Dazza !!
 I haven't seen the error lately, but if I do see it again, I'll get a screenshot and use the service request!

Recommendations for you