Exporting the results to CSV from Azure log analytics workspace

%3CLINGO-SUB%20id%3D%22lingo-sub-2108873%22%20slang%3D%22en-US%22%3EExporting%20the%20results%20to%20CSV%20from%20Azure%20log%20analytics%20workspace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108873%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20i%20am%20trying%20to%20export%20the%20results%20of%20KQL%20Query%20in%20Azure%20log%20analytics%20workspace%20the%20results%20have%20some%20sort%20of%20limit%20and%20not%20all%20results%20are%20being%20exported..%20What%20could%20be%20reason%20%3F%20i%20can%20see%20the%20results%20at%20the%20bottom%2C%20but%20only%20get%2050%20rows%20when%20try%20to%20export%20to%20CSV%20file.%26nbsp%3B%3CBR%20%2F%3EI%20tried%20changing%20the%20page%20size%20from%2050%20to%20200%20rows%20but%20still%20same%20issue.%20Its%20not%20exporting%20the%20results%20from%20all%20other%20pages..%20What%20could%20be%20the%20reason%20%3F%20is%20there%20anything%20i%20need%20to%20change%20%3F%20Help%20this%20rookie%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2109316%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20the%20results%20to%20CSV%20from%20Azure%20log%20analytics%20workspace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2109316%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738824%22%20target%3D%22_blank%22%3E%40mal20202020%3C%2FA%3E%26nbsp%3B%20Try%20to%20remove%2Fcomment%20the%20line%20%2F%2Flimit%2010%20from%20your%20kusto%20query%20and%20check%20it%20out.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2108993%22%20slang%3D%22en-US%22%3ERe%3A%20Exporting%20the%20results%20to%20CSV%20from%20Azure%20log%20analytics%20workspace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2108993%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F738824%22%20target%3D%22_blank%22%3E%40mal20202020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20result%20of%20the%20query%20%3F%20You%20are%20using%20the%20limit%20operator%20and%20the%20consequence%20is%20you%20limit%20the%20number%20of%20records%20in%20the%20result%20.%20What%20happen%20when%20you%20increase%20the%20limit%2010%20to%2050%20or%20100%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

When i am trying to export the results of KQL Query in Azure log analytics workspace the results have some sort of limit and not all results are being exported.. What could be reason ? i can see the results at the bottom, but only get 50 rows when try to export to CSV file. 
I tried changing the page size from 50 to 200 rows but still same issue. Its not exporting the results from all other pages.. What could be the reason ? is there anything i need to change ? Help this rookie please

2 Replies

@mal20202020 

 

Hi 

What is the result of the query ? You are using the limit operator and the consequence is you limit the number of records in the result . What happen when you increase the limit 10 to 50 or 100 ? 

 

@mal20202020  Try to remove/comment the line //limit 10 from your kusto query and check it out.