Forum Discussion

Jagan_Gadipally's avatar
Jagan_Gadipally
Regular Visitor
3 years ago

PostGreSQL connection in Power BI through ODBC

Hi,

I have connected POSTGreSQL through ODBC in PowerBI. While calling a procedure , it is not showing the data of cursor and it is showing cursor name only. Stored Procedure showing output in PGAdmin perfect but not fetching in Power BI. Please help me.
Please refer below snapshot. FYI, input details are changed in below Pic. Waiting for quick solution

 


Regards,

Jagan

Need Help

2 Replies

  • marcelsmaglhaes's avatar
    marcelsmaglhaes
    Super User
    3 years ago

    Hey Jagan_Gadipally !

     

    You have tried to use something like that below? 

    To consult the data:  SELECT  *  from your_func()  

    To execute the function: SELECT your_func(param1, param2, ..., paramN)

      

    • Jagan_Gadipally's avatar
      Jagan_Gadipally
      Regular Visitor
      3 years ago

      Thank you marcelsmaglhaes for quick reply. Its not working.