sql query with Where condition

[sowmyar]

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

[amitchandak · Accepted solution]

@sowmyar , Create a view in the database and after you publish the file, change the view and refresh the dataset in power bi service.