Remove the API limit of 500,000 rows / 64 MB of data, or have the API return an error message or an empty dataset
The current way the API handles the 500,000 row / 64 MB data limit is a problem when querying data from Application Insights into Power BI. As of the moment, no indication is given in Power BI if the API limit is exceeded and partial data is returned. That leaves every Power BI dashboard based on Application Insights unreliable and potentially misleading. If raising the API limit is not an option, then please have Application Insights return an error message or an empty dataset, so it becomes evident for the dashboard manager that the API limit has been exceeded, allowing the dashboard manager to redesign the query.
Thanks for the feedback. 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.