Dec 14 2017
11:04 AM
- last edited on
Apr 07 2022
04:50 PM
by
TechCommunityAP
Dec 14 2017
11:04 AM
- last edited on
Apr 07 2022
04:50 PM
by
TechCommunityAP
I am running
AzureDiagnostics
| where TimeGenerated > ago(91d)
| where ResourceType == "APPLICATIONGATEWAYS" and OperationName == "ApplicationGatewayPerformance"
However, I am not getting more than 12 days "ago" of data. Is this a limit to the tool, am I hitting a row limit, or is there a historical limit to how much data I can pull?
I am doing the export to Power BI M query and running it from there.
Thanks!
Dec 14 2017 02:51 PM
Hi,
Could you please add a "| count" at the end of your query to confirm how many rows are being returned? The Log Analytics UI will cut you off at 10,000 and when importing to Power BI, you'll be limited to 500,000 rows or Power BI's data model limit. If this is not the case, please let us know, and we'll dig into what else the issue might be.
Thanks,
-Evgeny
Dec 21 2017 05:56 AM