Running Powerbi Report builder report Error.

[Anonymous]

Whenever i run the paginated report on server. I get this error. Please help.

[Anonymous]

I fixed this by changing the connection strings and it worked!.

[v-deddai1-msft]

Hi @Anonymous ,

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

[Anonymous]

Yes it is oracle database. It works well locally but when uploaded to server gives this error.

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

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=sql-server-ver15

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

[Anonymous]

Yes. It is only happening when i run the report on server.