Maximum Results in Log Analytics Workspace

Question

I have a query for Azure AD logs in my Log Analytics workspace as follows (IP changed):

set notruncation;
SigninLogs
| where IPAddress != '1.2.3.4' |summarize SigninCount = count() by Identity, tostring(LocationDetails.city), AppDisplayName, ClientAppUsed
|sort by Identity asc

When my results are presented I am getting an alert at the bottom of the results:

Results were limited to the first 250 rows.

How can I avoid this and present the full results?

Answer 1

Workbooks are designed to create interactive reports or analysis narratives. they are not intended to be used as data explorer and moreover it is difficult to consume rows of data. So it is best to optimize filters

Having said that you can see more than 250 rows and recommend use this with caution !
now in order to expand the result set you can change it by going to advanced settings in edit mode and inputting the value here

Answer 2

workbooks are interactive canvases, they are not really intended to present long "sheets" of text.
but there is a partial solution here: in edit mode, choose Advanced Settings and then select "Show open external query button when not editing"
This will add a small Log Analytics icon in the top right corner of your table, clicking this icon will take you to Log Analytics experience, with the same query - and LA can show up to 10K records in the UX + gives you additional flexibility into analyzing the results (by changing the query or simply working with the table)

Hope this helps