Forum Discussion

Sarazin73's avatar
Sarazin73
Frequent Visitor
6 years ago

Connection string to snowflake database in Power BI Service

Hello,

 

i need to add a new datasourse to my existing gateway and the provider is Snowflake database. What is the correct connection string format to put in the textbox zone in the Power Service page, please ? Have you sample to give it to me ? Thanks

Need Help

4 Replies

    • Sarazin73's avatar
      Sarazin73
      Frequent Visitor
      6 years ago
      thanks V-lianl-msft for your reply, but the problem is not on the desktop side. When i published my dashboard on power bi service and i want to refresh datas from there, i must configure new connection string on the gateway too. I don't know what is the format/structure of this string for Snowflake provider (or ODBC for Snowflake if it works ?)
      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago

        Hi Sarazin73 ,

         

        Try the following to see if it works

        Provider=MSDASQL.1;Persist Security Info=True;User ID=USER_NAME;Extended Properties="DSN=DSN_NAME;DATABASE=DATABASE_NAME;Description=Snowflake DSII;ROLE=ROLE_NAME;SCHEMA=PUBLIC;SERVER=instancename.snowflakecomputing.com;TRACING=4;UID{USER_NAME};WAREHOUSE=WAREHOUSE_NAME;";Initial Catalog=DATABASE_NAME;Pwd=PASSWORD

         

        If the problem persists,i would suggest you to create a support ticket to solve your problem. 

         

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