topic Unable to render paginated report :A data source used by this report returned an error. in Report Server

Unable to render paginated report :A data source used by this report returned an error.

Anonymous — Tue, 05 Sep 2023 15:53:32 GMT

We have developed a report with stored procedure in oracle sql with some dynamic paramters. The report is working fine in Power BI Report Builder but when we publish it to the power bi service after giving inputs to the parameters in the report. It throws the below error.

Unable to render paginated report

A data source used by this report returned an error. Received error payload from gateway service with ID 230823

Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: OracleException:Oracle.DataAccess.Client.OracleException (0x80004005): ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to

Can you please let me know is there any problem with the report building style as the reports works fine in the local but not in the service

Re: Unable to render paginated report :A data source used by this report returned an error.

Medina — Thu, 02 Nov 2023 02:43:10 GMT

Hi,

Were you able to fix this? It looks like column 7: PLS-00306: wrong number or types of arguments in call to isn't compatible with one of the parameter value(s) sent.

Please let us know.

Re: Unable to render paginated report :A data source used by this report returned an error.

Dalimil — Mon, 06 Nov 2023 14:22:36 GMT

Hi, im having the same problem. Unfortunately still no luck on my side. Works well on local. Gives error while calling on Service via Gateway.

So far only got woraround to work in some cases - use SQL instead of calling a procedure directly. And in this case it works for some reason. Although it has its flaws and is way more complex to:

DECLARE P_RC SYS_REFCURSOR;

BEGIN

MSREPORT.REPORT_462.REPORT_462 (P_RC);

DBMS_SQL.RETURN_RESULT(P_RC);

END;

Re: Unable to render paginated report :A data source used by this report returned an error.

DalimilFisar — Mon, 04 Dec 2023 11:25:50 GMT

unfortunally not, the workaround works, but only for single select parameters. For multiselect i need to use select directly rewrite some logic from procedure and use :p_parameter to input values directly to SQL select. The thing im not understanding is why when I use procedure directly it works in report build but it gives error when published to power bi service

Re: Unable to render paginated report :A data source used by this report returned an error.

Anonymous — Tue, 06 Feb 2024 21:23:24 GMT

I have the same issue has anyone found a solution for this yet?