Here is some sample code, it's pulling from a view. When I run it in SQL it returns the correct results but in powergadgets it returns 5000 and some results?
SELECT
[Ticket Number]
,[status]
,[Company Name]
,[site]
,[summary]
,[detail]
FROM [companyname].[dbo].[v_table1]
where [status]='assigned'