Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

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

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    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

6 Replies

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        johnt75
        Super User
        4 years ago

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