ODBC: ERROR [HY000] [Microsoft][Snowflake]

[svp1000]

Hi everyone, 

I am connecting to a snowflake database and it works on PowerBI Desktop but once I upload the dashboard to workspace, I have an error when I try to connect to datasource to Snowflake :
Failed to update data source credentials: ODBC: ERROR [HY000] [Microsoft][Snowflake] (4) REST request for URL <the link to my URL> failed: CURLerror (curl_easy_perform() failed) - code=6 msg='Couldn't resolve host name'.

Because of this error I can't modify the updates.
On the desktop version, everything works properly and updates are also carried out. 

[svp1000 · Accepted solution]

There was no way to resolve this issue. We had to use a on premises data gateway to resolve for this. Now the database is connected in the OPDG and then we use that gateway to refresh the dashboard

[Anonymous]

Hi,@svp1000 

I am glad to help you. 

Regarding this issue you are experiencing, you can try to troubleshoot and resolve the issue by following the steps below: 

Check Network Configuration: Ensure that your network settings allow Power BI Service to connect to Snowflake. 

Verify Snowflake Credentials: Double-check that the credentials used for Snowflake in Power BI Desktop are still valid and have not changed. 

Please make sure that the information is filled in correctly when gateway New Connection is created. If there are some special connection characters in the Server name, it is recommended that you choose to copy them and enter them. 

Here's some related documentation that I hope you find helpful: 

Power Query Snowflake connector - Power Query | Microsoft Learn 

Connect to Snowflake with Power BI - Power BI | Microsoft Learn 

Power BI SSO to Snowflake | Snowflake Documentation 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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

[svp1000]

Hi, thanks for responding to me on this - 

Check Network Configuration: Ensure that your network settings allow Power BI Service to connect to Snowflake. - how do i do this?

Verify Snowflake Credentials: Double-check that the credentials used for Snowflake in Power BI Desktop are still valid and have not changed.  - I have checked this and it is the same as what is on PowerBI

[Anonymous]

Hi, @svp1000 

May I ask if you have already solved this issue? If it has been resolved, please share your solution and accept it as a solution, this will help other members of the community who are experiencing similar issues to resolve the issue more quickly.

If it has not been resolved, I would like you to provide the full procedure for doing so. Please take care to remove all sensitive information and we will do our best to provide a solution to your issue.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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

[svp1000]

Hi @Anonymous - I'm still facing this issue. I would like to connect to resolve this issue. How do I check my network configuration and firewall settings 

[Anonymous]

Hi,@svp1000 

You can go ahead and check if your firewall settings are preventing Power BI Service from connecting to Snowflake.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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