Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Sarazin73 ,
You can refer to this document:https://docs.microsoft.com/en-us/power-bi/desktop-connect-snowflake
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.