Forum Discussion
Unable to render paginated report :A data source used by this report returned an error.
Hi 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 a...
Medina
Resolver I
Resolver IHi,
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.
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
