Tuesday, January 9, 2024

Oracle: Connection request timed out

Oracle: Connection request timed out - Power BI

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

If this is temporary issue just do the demand refresh again(4 to 5 times) it will sort. Still after doing 5 times refresh still issue exist then you need increase connection time out in pbix file where they have return runtime queries by going to power query editor. The red higlighted area or create View of runtime query used in pbix or Check any other parrallel scripts running while refreshing stop and refresh. 


or you can change in Advance editor refer the below screenshot



No comments:

Post a Comment

Oracle: Connection request timed out

Oracle: Connection request timed out - Power BI Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDa...