Cannot connect paginated report in the service to Oracle

Cannot connect paginated report in the service to OracleFollow
James Watts
James WattsOct 21, 2022 10:56 AM
I have a (Report Builder) paginated report that works perfectly on the desktop, talking to an Oracle …
1. Cannot connect paginated report in the service to Oracle

Bronze Contributor
James Watts
Posted Oct 21, 2022 10:56 AM
I have a (Report Builder) paginated report that works perfectly on the desktop, talking to an Oracle database. However, once I publish it to the service, and set up the gateway connection, it returns error an error when I try to run it, as below. I’m running the latest version of Report Builder, and datasets and dataflows using Oracle have no problems. Are there additional config steps required for using Oracle data sources in paginated reports on the web service ?

—————————————————————————————-
Unable to render paginated report
Could not connect to the data source.

If you contact support, please provide these details.
Hide Details
Timestamp (UTC)2022-10-21T14:49:08.926Z
Root Activity IDb2e6a530-a6ec-02f2-6a0f-8b1f80fb61e4
Session ID0000xxxxxxx
Tenant IDxxxxxxxx
Cluster URIhttps://wabi-uk-south-b-primary-redirect.analysis.windows.net/
Report IDxxxxxx
Viewer version2022.10.2.3057

——————————
James Watts
Business Intelligence Analyst
——————————

2. RE: Cannot connect paginated report in the service to Oracle

Bronze Contributor
James Watts
Posted Oct 21, 2022 11:07 AM
I’ve tried rebuilding the datasource in the paginated report, and now on the service have a different error:

A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError. An exception encountered while creating the target data source Unable to find the requested .Net Framework Data Provider. It may not be installed.

——————————
James Watts
Business Intelligence Analyst
——————————