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.

klinejordan's avatar
klinejordan
Icon for Advocate II rankAdvocate II
4 years ago

Anonymous did you ever get this working (calling Oracle stored procedure through gateway)

Sandie's avatar
Sandie
New Member
4 years ago

I have recently had this issue and opened a case with Microsoft -- it is a known limitation at present; but did receive feedback just this week from the Power BI Engineering group that they are going to add this functionality gap as a feature request to be included on their roadmap -- no ETA as of yet though on when this will be addressed.