Raise the 5000 row limit on the Azure Application Insights REST API
https://dev.applicationinsights.io/apiexplorer/events?appId=DEMO_APP&apiKey=DEMO_KEY&eventType=requests&$filter=startswith(request%2Fname%2C%20%27GET%27)%20and%20(request%2FresultCode%20ne%20%27200%27%20or%20request%2Fduration%20gt%20500.0) currently lists 500 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 integrate with SQL, POPWER BI,etc . We usually need to do the operation like parse it inside SQL and do some dynamic nesting-heavy.
Thanks for your feedback and its 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.
John P White commented
For Power BI, you can use functions as a workaround - https://whitepages.unlimitedviz.com/2020/11/exceed-the-500000-row-limit-in-application-insights-and-log-analytics-with-power-bi/