Power BI connects to snowflake database but data import throws error.

[Anonymous]

Hi Everyone,

I am connecting Power BI to snowflake database using Azure ID Authentication, and it is connecting successfully.

But when I import data to Power BI using same connection It throws below error:

Failed to save modifications to the server.
Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Snowflake] (25)
Result download worker error: Worker error: [Microsoft][Snowflake] (4)
REST request for URL <URL>
failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't resolve host name'.

Thing to be noted here is that the error is not consistent , sometime data-import tries importing data at some count (sometime 100s, sometime 1000s or sometime millions also) and  then throws the error as mentioned above, And sometime it throws error without trying to import any single row also - As shown in below screenshots :

can anybody please help me to find the route cause or to solve the issue.

Thank you

[Anonymous]

Hi @Anonymous ,

Please review the contents in the following link, hope they can help you.

PowerBI connection fails with error: couldn't resolve host name

ODBC Connection to Snowflake Databse

Best Regards

Rena

[Anonymous]

Hi @Anonymous 

Tried this, the link didn't help.

[amitchandak]

@Anonymous , Can you check connection timeout setting