Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We are trying to configure the Power BI Snowflake connection for reporting purposes. We followed the Microsoft documentation by setting up the SSO, a few questions:
Solved! Go to Solution.
Hi, @117325
Yes, you can use Azure Key Vault to store the password for the service account securely and retrieve it programmatically during runtime. Here are the high-level steps you can follow:
Bring your own encryption keys for Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @117325
Yes, you can use a service account for initial Azure AD authentication. This is a common practice for connecting to Snowflake from Power BI.
Regarding your second question, while Azure Key Vault can be used to store and manage secrets, it is not a replacement for Azure AD authentication. You will still need to use Azure AD to authenticate to Snowflake. However, you can use Azure Key Vault to securely store the credentials needed to authenticate with Snowflake.
I would recommend following the Microsoft documentation for setting up the Power BI Snowflake connection, as it provides a step-by-step guide for using Azure AD authentication and securely storing credentials using Azure Key Vault. Connect to Snowflake with Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @117325
Yes, you can use Azure Key Vault to store the password for the service account securely and retrieve it programmatically during runtime. Here are the high-level steps you can follow:
Bring your own encryption keys for Power BI - Power BI | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.