Restricting Data Load Error

[GlynMThomas]

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)

[amitchandak]

@GlynMThomas , is this date add syntax correct ?

[GlynMThomas · Accepted solution]

It's ok I've fixed it. The query editor was malforming the code so I had to use the advanced editor to correct it.

Works now.