Cannot Create New Connection. Timeout expired. The timeout period elapsed prior to....

[gilmorez]

I am unable to create a new connection to an Oracle data source via an on premises gateway. I have downloaded Power BI Desktop onto the server the gateway is intalled on and can connect through there no problem (using TNSNAMES.ORA). I only can't connect to it from Power BI Service.  The error I receive when attempting to connect is as follows:

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

Gateway on endpoint 'x' is unreachable.

Timeout expired. The timeout period elapsed prior to completion of the operation. 

Any ideas? Need more details?

[v-jianpeng-msft]

Hi, @gilmorez 

Thanks for the reply from @lbendlin , please allow me to provide another insight:

First of all, you can configure your gateway connection according to the official documentation provided by Oracle, and make sure that your steps are the same as those provided by Oracle, so that you can avoid many problems. For more information, please click on the link below:

microsoft-powerbi_service-gateway-adw.pdf (oracle.com)

In addition, you also need to install the corresponding OCMT tool according to the official documentation below, please refer to the link below for details:

Manage your data source - Oracle - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

yes, needs more details.  How are you connecting to the Oracle data source from your desktop?  Native driver, ODBC? TNSNAMES.ORA?

And have you replicated that setup on all gateway cluster members?

[gilmorez]

We are using TNSNAMES.ORA. All setups are the same.

[lbendlin]

have you confirmed they all work though?

[gilmorez]

Yes

[lbendlin]

Do the network test on all gateway cluster members. Do you need a proxy in your network?