Forum Discussion
Oracle Stored Procedure
How to call oracle stored procedure with or with out paramenter using power BI Kindly share the steps execute command is not working Details: "Oracle: ORA-00900: invalid SQL statement"
Hi rizwanvohra ,
Could you want to know how to get data from Oracle database in power bi? If so, you could refer to below link:
https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database
And if you want to use the parameters to switch any data, you could refer to below link:
https://biinsight.com/power-bi-desktop-query-parameters-part-1/
Regards,
Daniel He
Thanks of the reply
I need to know the how call Oracle Stored procedure using power BI
Hi rizwanvohra ,
Sorry that I am not familiar with Oracle, maybe you could refer to below link about execute SQL Server Stored Procedure in Power BI:
Regards,
Daniel He
Have you managed to call oracle SP from PBI Desktop?
I'm guessing ref cursors are still not supported?
