Forum Discussion

kcdavi01's avatar
kcdavi01
Frequent Visitor
6 months ago
Solved

Connecting to Data: PostgreSQL (Function) error

Hi all, I hope all is well! I have a client that would like to connect to a PostGreSQL function (vs a table) but we're running into an error message when trying to connect via a Power Query M script:...
Need Help
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    6 months ago

    Hi kcdavi01 ,

     

    Believe that you problem is with the syntax of the Passed where you have added and additional '

     

     

    Try the following:

     

    PostgreSQL.Database("SERVER", "DATABASE", [Query="SELECT * FROM FUNCTION('" & StartDate & "', '" & EndDate & "', '" & DataType & "', '" & Status & "')"])

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 months ago

Hi kcdavi01 ,

 

Believe that you problem is with the syntax of the Passed where you have added and additional '

 

 

Try the following:

 

PostgreSQL.Database("SERVER", "DATABASE", [Query="SELECT * FROM FUNCTION('" & StartDate & "', '" & EndDate & "', '" & DataType & "', '" & Status & "')"])