Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Data Refresh Error - Snowflake

Hello

On Power BI desktop. I have an error when I try to refresh data (I am connected to datasource through Snowflake) and due to this error I can't modify the updates.:
ODBC: ERROR [HY000] [Microsoft][Snowflake] (4) REST request for URL *** failed: CURLerror (curl_easy_perform() failed) - code=28 msg='Timeout was reached' osCode=10060 osMsg='Unknown error'.

It would be appreciated if you know how I can solve it.

Kind Regards

Need Help

3 Replies

  • sudhisami_azure's avatar
    sudhisami_azure
    Frequent Visitor
    2 years ago

    Check this :

     

    1. Increase the Command Timeout
    Navigation : File > Options and Settings > Options.
    In the left pane, select Data Load.
    Increase the Maximum allowed timeout in minutes for the ODBC connection.

    2. Check Network Connectivity VPN, network connection
    3. ODBC Driver Update

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thank you for your response, but I can not find "ODBC connection",
      as you can see in the photo

       

  • SShaikh's avatar
    SShaikh
    Frequent Visitor
    1 year ago

    Set Timeout in Power Query Editor

    1. Open Power Query Editor:
      • Click Transform Data in Power BI Desktop.
    2. Modify Query Timeout:
      • In the applied steps pane, find Source or the step where the Snowflake connection is used.
      • Click the gear icon ⚙️ next to the step to edit the source.
    3. Adjust Command or Connection Timeout:
      • Click Advanced options.
      • Set the Command or Connection timeout in seconds (e.g., 600 for 10 minutes,1800 for 30 minutes).

    Click OK.