Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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)
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Thank you marcelsmaglhaes for quick reply. Its not working.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |