Forum Discussion

117325's avatar
117325
Frequent Visitor
3 years ago
Solved

Power BI Snowflake Connection

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: Are we supposed to utilize a ser...
Data Protection
Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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:

    • 1. Create an Azure Key Vault instance and store the password for the service account as a secret in the Key Vault.
    • 2. In your Power BI report, use the Azure Key Vault REST API to retrieve the secret during runtime.
    • 3. Use the retrieved password to authenticate with Snowflake.

    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.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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.

jikuja's avatar
jikuja
Frequent Visitor
1 year ago

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

 

Linked documentation does not even mention key vault. Did you provide correct link?