Raise the 500,000 row limit on the Azure Log Analytics REST API
https://dev.loganalytics.io/documentation/Using-the-API/Limits currently lists 500,000 as the limit in the number of rows a query can return. It would be helpful if we could raise this limit to make it easier to create PowerBI dashboards which slice and dice historical data, where in aggregate the raw data exceeds 500k rows. In practice this allows the dashboards to look further back in time.
Thanks for the valid suggestion. Your feedback is now open for the user community to upvote & comment on. This allows us to effectively prioritize your request against our existing feature backlog and also gives us insight into the potential impact of implementing the suggested feature.
Craig Martin commented
Would love to see paging in the API for large result sets. Clients are going to find ways around the 500K limit but forming their own queries that fit under the limit, so the 500K limit is not likely defending the API from clients.
John P White commented
In the meantime, if you're using Power BI with it, here's a woraround - https://whitepages.unlimitedviz.com/2020/11/exceed-the-500000-row-limit-in-application-insights-and-log-analytics-with-power-bi/
I would request to increase the row limit on query work bench and azure monitor logs as well