Forum Discussion

RakeshSinghr's avatar
RakeshSinghr
Icon for Resolver I rankResolver I
6 years ago
Solved

Oracle Stored Proc in PBI Desktop

Hi,       I need help with executing an oracle stored procedure that simply returns few columns. I'm getting "Oracle:ORA00900: invalid SQL statement" error.   I'm using ref cursor - see below co...
Need Help
  • RakeshSinghr's avatar
    RakeshSinghr
    6 years ago

    For anyone in the same boat as me - Oracle stored proc with ref cursors can be executed within power bi desktop. It just need to be run with cursor variable declaration.

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
6 years ago

Hi Rakesh

Thanks for the Code.

I am not getting any error during connection but when tried to save changes, getting error missing right paranthasis. Checked the syntax in advanced editor and everything looks correct but still I can see error.

Any ideas.

Thanks

siva

siva_powerbi's avatar
siva_powerbi
Icon for Helper IV rankHelper IV
6 years ago

Thanks Rakesh,

Code is working, didn't do anything special just restarted the Power BI.

Thanks

Siva