I am receiving an error when connecting Power BI to Snowflake.
"Unable to Connect - We encountered an error while trying to connect. Details: "The server name should only be a host name".
I am putting our server in as:
https://xxxxxx.east-us-2.azure.snowflakecomputing.com
And I have put in the name of the Warehouse (compute) that I want to use to process the load:
PRD_BI_GENERAL_US_XS
I chose Import mode and left all the optional fields blank.
Either from Power BI Desktop or Power BI service, the target Server when connecting to a Snowflake account has to be the hostname, therefore it doesn't need the HTTPS:// which instead is required to get to the Snowflake Account via Web UI.
An example would be: contoso.snowflakecomputing.com
Also, in order to successfully connect from Power BI you have to impersonate a Snowflake Role that is allowed 'Usage' permission on the Virtual Warehouse and the Database you want to get to. This can be done by having that specific Role as the Default Role for your Login.
Note that, since February 2021, Power BI Desktop supports Snowflake custom roles.
Reference:
