How To Access Azure Key Vault Secrets Through Rest API Using Power BI

[Anonymous]

I'm trying to access Azure Key vault secrets through Power BI but I'm unable to find a way to do so.

I found a way to do that in Postman.
Can you help or convert these Postman requests into Power BI query so I can use it.

https://www.c-sharpcorner.com/article/how-to-access-azure-key-vault-secrets-through-rest-api-using-p... 

[BIBB]

You may want to look at this post, which contains a walkthrough and a video on accessing your Key Vault secrets in Power BI using a custom connector and a gateway. 

Securing Your API-Power BI Data with Azure Key Vault (bibb.pro)

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

 Please read blog about web service and post requests in power query.

https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/

You can also refer to the similar case in stackoverflow:

https://stackoverflow.com/questions/50464192/post-method-in-power-bi

And you could refer the following article,it tells:

1. you can use azure key vault with power BI premium. Power BI encrypts data at-rest and in process. By default, Power BI uses Microsoft-managed keys to encrypt your data. In Power BI Premium you can also use your own keys for data at-rest that is imported into a dataset . This approach is often described as bring your own key (BYOK). We can configure Azure Key Vault, a tool for securely storing and accessing secrets, like encryption keys. You can use an existing key vault to store encryption keys, or you can create a new one specifically for use with Power BI.

Configure your key vault in the following way:

- Add the Power BI service as a service principal for the key vault, with wrap and unwrap permissions.

• Create an RSA key with a 4096-bit length (or use an existing key of this type), with wrap and unwrap permissions

• Recommended: Check that the key vault has the soft delete option enabled.

  Note: Power BI BYOK supports only RSA keys with a 4096-bit length. Configure Key vault and service principal

2. We can connect azure sql db with power BI. The process is not much complicated. All the steps are straight forward.

• first you need to configure firewall settings for azure sql db server.
• use sql DB connector to connect to SQL DB
• select the sql server and database to query the data. Reference

To learn more details ,refer:

https://stackoverflow.com/questions/68355392/power-bi-and-azure-key-vault 

Best Regards

Lucien