Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GlynMThomas
Resolver I
Resolver I

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.

 

GlynMThomas_0-1594727054841.png

 

GlynMThomas_1-1594727190504.png

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

1 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.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.