Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Whenever i run the paginated report on server. I get this error. Please help.
Solved! Go to Solution.
Hi @elnabeleon ,
Did you install Managed ODP.NET for paginated report? Please refer to https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I fixed this by changing the connection strings and it worked!.
Hi @elnabeleon ,
Did the paginated report works well in power bi report builder? It seems to be a datasource error. Is your data source oracle? Please refer to : https://www.codeproject.com/Questions/760991/Invalid-parameter-binding-calling-Oracle-package-p and https://www.codeproject.com/Questions/102624/invalid-Parameter-binding-parameter-name
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Yes it is oracle database. It works well locally but when uploaded to server gives this error.
Hi @elnabeleon ,
Did you install Managed ODP.NET for paginated report? Please refer to https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Yes. It is only happening when i run the report on server.