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

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