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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Still got the problem.. 😞