How your query looks like? According to documentation you should be able to get up to 5000 results:
See limitation seciont. Didn't you have any TOP function in query?
SELECT TOP(distinct(userid),2000) from usersession where useraction.application = '<App_Name_String>' group by userid order by user id
which encodes to
I have the same problem, No matter what i set, the response is only 50 rows max in a managed solution.
We try with this kind of query:
SELECT usersession.ip, application, name, targetUrl,usersession.userId, startTime FROM useraction WHERE usersession.userType = "REAL_USER" GROUP BY usersession.ip, application, name, targetUrl,usersession.userId,startTime ORDER BY usersession.ip, startTime
To group all users by ip and application.by default it would be the last 2 hours. that's aprox at least 10k of user actions (5k per hour) but ended only showing no more than 50 user ressults.