Running Powerbi Report builder report Error.

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

v-deddai1-msft
Community Support
5 years ago
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
  Not applicable
  5 years ago
  Yes it is oracle database. It works well locally but when uploaded to server gives this error.
  - v-deddai1-msft
    Community Support
    5 years ago
    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
Not applicable
5 years ago
I fixed this by changing the connection strings and it worked!.

Forum Discussion