Forum Discussion
Refresh Failure
Hi. I'm trying to refresh my dataset through Power BI service and get the following error: Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [08001] timeout expired
DM_E...
Ok, the refresh doesn't work again. But now I have the same timeout error on some of the reports, and a new one on others:
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":"ODBC: ERROR [08001] timeout expired\n"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"database=mydb;driver={PostgreSQL Unicode(x64)};port=5432;server=myserver"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: owners.
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: dfce0d2c-7e1e-4979-8010-7e4f8f4103a5
Request ID: bda0df3d-8156-4e06-8ba5-e194b7441688
Time: 2021-05-14 17:03:58ZThough the data source and the gateway are the same for all the reports.