Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Community Support
5 years ago

Hi Anonymous ,

 

I think the ODBC: ERROR [08001] occurred because the data source connection timed out. Try to increase the CommandTimeout and the ConnectionTimeout parameters to see if it works.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-kkf-msft ,

    Thank you for looking into this.

    I've set the timeout values as you advised and republished the data source, but I get the same error still. 
    When I hit the refresh button in Power BI service, it takes around 2 minutes, then fails.

    Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [08001] timeout expired

DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Odbc
Microsoft.Data.Mashup.ValueError.DataSourcePath: [commandtimeout=#duration(0,2,0,0),ConnectionTimeout=#duration(0,2,0,0)];database=cience-hubspot;driver={PostgreSQL Unicode(x64)};port=5432;server=157.245.182.184
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 809cbaf9-dd22-43ca-90ef-270f4977994e
Request ID: e859ea15-8ae7-8da9-d518-c103d9c7b3a5
Time: 2021-05-18 18:03:38Z