Unable to connect to postgresql server using query (Expression.Error: The key didn't match any rows)

[Anonymous]

Hi,

I have a connection to postgresql server through ODBC that works ok. A table has become too large and now every time I need to update it, it takes too much time.

The only idea I came up with was to prior to retrieving of ALL the data from the table, write a query to filter it, so I get only the data I need.

Right now when I write my SQL code on the window shown below (sorry the language) and press accept, it throws Expression.Error: The key didn't match any rows.

Any idea of what should I do?

Thanks

[johnt75]

Create a new blank query and use the below

let
	Source = Odbc.Query("dsn=Reporting Server", "
select * from my_table where my_filter = 1
	")
in
    Source

You can add any steps needed afterwards to change data types etc

[Anonymous]

HI johnt75,

I didn't fully understand your reply. This is what I did.

And got this error

What am I doing wrong?

Thanks!

[johnt75]

remove the ; at the end of your query, it should be fine then

[Anonymous]

Still got the problem.. 😞

[johnt75 · Accepted solution]

I see now. Copy all the code from the custom step you added, from "let" to "in Source", then open up Advanced Editor. Delete everything and paste in your code there

[Anonymous]

Thank you, finally I just copied the SQL code (without the ; at the end, that's why it didn't work when I first tried) and it worked.