Restricting Data Load Error

Hi,

I'm trying to restrict the data coming into a dashboard by editing the SQL in the native query and adding a filter. This is reading from a view. When I run the SQL query in SSMS it runs fine, however when I add it to power bi it keeps coming back with "The key didn't match any rows in the table". This is on a completely blank power bi file.

The query isn't the one I'm using but an example of what it looks like (for security reasons)