Forum Discussion

AConfusedUser's avatar
AConfusedUser
Copper Contributor
Dec 14, 2017

Ago() not returning all rows or row limits for query?

I am running AzureDiagnostics | where TimeGenerated  > ago(91d) | where ResourceType == "APPLICATIONGATEWAYS" and OperationName == "ApplicationGatewayPerformance" However, I am not getting mo...
Azure Log Analytics
azure monitor
Evgeny Ternovsky's avatar
Evgeny Ternovsky
Icon for Microsoft rankMicrosoft
Dec 14, 2017

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