Is it possible to decrypt SQL data encrypted with a key in Azure Key Vault in Power BI Desktop?

[arpost]

Greetings, all. Hoping someone can help answer this question. We are using Power BI Premium and have a situation where we are connecting to an Azure SQL database that has sensitive fields encrypted using a key stored in Azure Key Vault. We would like to decrypt that data in our BI reports.

Does anyone have a suggestion for how we can go about achieving this? I've read some things online about BYOK and Azure Key Vault, but I wasn't sure if that applied in this scenario since we have already done the encryption on the DB side.

[arpost]

@v-xiaotang, thanks for the reply. Unfortunately, no, as that functionality isn't supported in Power BI Desktop.

[v-xiaotang]

Hi @arpost 

Does this article help? Using SQL Server Always Encrypted data in Power BI Report Builder (Paginated Reports) - Visual BI So..., it says you need to have the client certificate installed on the machine where you are decrypting the data. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.