Connection request timed out

[Gurukiran003]

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Oracle: Connection request timed out"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"frparvm62343741/apacopsprod"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Connection request timed out"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: ALL DEMANDS.
Cluster URI: WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
Activity ID: f76dc813-bca5-407d-a353-23a36cd80823
Request ID: 48400edb-dd8b-118d-0989-42ca2edc5ed4
Time: 2023-02-27 11:31:40Z

I am getting the above issue and we don't have any issue in

[Gurukiran003]

The issue sorted for me by Increasing the Connection Timeout in PBIX, where to update the Connection Timeout in PBIX? Check out the below link.

https://quantawave.blogspot.com/2024/01/oracle-connection-request-timed-out.html

[v-yueyunzh-msft]

Hi , @Gurukiran003 

According to your error message provided, it seems that a timeout error was encountered when configuring the connection of Oracle data sources for the gateway, and the error appeared when the connection request, it should be a connectivity problem, if it is convenient, you can install and configure the Oracle connection environment on the gateway computer, and install Power BI desktop to determine whether there is any problem with the connection. If Power BI desktop can be successfully connected to the gateway computer, you need to collect gateway logs for further local research.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[Gurukiran003 · Accepted solution]

Hi Aniya Zhang Thanks for your Reply, It was causing due to connection waiting time was default.

The issue sorted for me by Increasing the Connection Timeout in PBIX, where to update the Connection Timeout in PBIX? Check out the below link.

https://quantawave.blogspot.com/2024/01/oracle-connection-request-timed-out.html