Forum Discussion
ODBC: ERROR [HY000] [Microsoft][Snowflake]
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.
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
6 Replies
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.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
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.
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
