Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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)
Solved! Go to 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.
@GlynMThomas , is this date add syntax correct ?
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |