How to call Oracle stored procedure from Power BI report builder(Paginated Reports)

Okay, I was running into this same issue with Paginated reports and this is what I have learned.

• Oracle 12c you can use the DBMS_SQL.RETURN_RESULT(CursorName)
• Orace 11g its not easy at all or very easy depending how you look at it.
  • Just write a sql statement, yes this can be a maintanence nightmare, but you work with what they give you.
  • Write a function that returns a cursor the use:
    • select extractvalue(column_value,'/ROW/LAST_NAME') LAST_NAME from table(xmlsequence(FunctionName(param)))
    • The above is slow and returns everything as a varchar

For 11g I tried to use pipeline functions, but it still doesn' work once I publish the report and it has to use the on premise gateway.  I am making one last ditch effort to see if the PBI Admins installed the ODP.net correctly on those gateway servers.

I hope this helped.