Paginated Report not working on PowerBI.com but works locally

[derekwilson74]

I have built a report using the Paginated report builder connecting to oracle that runs an SP.  It works on my local machine.  I have queries pulling values for parameters that get passed to the oracle sp.  Everything works locally.  When I deployed to PowerBI.com the parameters are populated so I know the report can read from the oracle database.  When I click view report and run the SP I get this error:

Unable to render paginated report

A data source used by this report returned an error.
An exception encountered while accessing the target data source
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'OUTPUT_DETAIL'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

[bradsy]

Seems like it should work. You might try the Get Help option from the service?

[derekwilson74]

I've looked at the documentation and get help.  The log files on the data gateway are not providing much information either.  Is there a way to see what is being passed from the report to the oracle database via the gateway....the actual string sent.

[Icey]

Hi @derekwilson74 ,

Has the issue been solved?

Best Regards,

Icey

[Icey]

Hi @derekwilson74 ,

Try to turn on "Additional logging" option and export gateway logs after reproducing the issue.

Reference: Troubleshoot the on-premises data gateway | Microsoft Docs

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.