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 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.

jikuja's avatar
jikuja
Frequent Visitor
1 year ago

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

 

How is CMK related with the steps you listed? Wrong link again?

 

Is there actual documentations for the steps you listed?