Forum Discussion

SaravananM's avatar
SaravananM
Frequent Visitor
2 years ago
Solved

Not able to create Oracle source connection in on prem gateway

I have a PowerBI report that uses Oracle as its data source, and it refreshes in PowerBI Desktop without any issues.

In PowerBI service, I am trying to create a new connection in the gateway for Oracle connectivity for our daily schedule, but I am encountering an ODAC error.

 

Note: I have installed Oracle Client 19c and configured TNS. It worked in PowerBI Desktop, and I was able to refresh the data without any issues.

 

Error Message : 

Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.
Details: : An error happened while reading data from the provider: 'The provider being used is deprecated: 'System.Data.OracleClient'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the supported provider.' Please have this information handy if you choose to create a support ticket. Session Id: 817f8b98-1dec-4b63-99e7-8c7c8eac7c59 RequestId: 9288c24f-b7df-42c6-9cb8-992365196c90 Cluster URI: https://api.powerbi.com Status code: 400 Time: Thu May 23 2024 12:09:47 GMT+0200 (Central European Summer Time)
Need Help

4 Replies