sql query with Where condition

Hi,

While importing data into Power bi I have written sql Query with where condition to restrict the number of records.After development while publisheing in need it for all accounts, but if i remove the where filter the data is too large that it continoulsy loads in desktop.Is there any other way to change directly in service

Thanks in Advance