Consuming always encrypted column data using KeyVault
Hi all, I need to build a paginated report in a premium workspace to consume data from Azure SQL database with always encrypted columns. These columns are encrypted using keys in KeyVault. I've read through a number of articles: Bring your own encryption keys for Power BI - Power BI | Microsoft Learn Despite switching on BYOK and adding my keyvault key, I keep getting the message 'power bi report invalid key store provider name azure_key_vault' when trying to consume the encrypted columns. After completing the steps in the linked article and running Get-PowerBICapacity -Scope Organization, it displays as: Id : xxxxxx DisplayName : Premium Per User - Reserved Admins : Sku : xxx State : Active UserAccessRight : Admin I note that above, the display name is Premium Per User - Reserved, yet our licenses are only Power BI pro. Could this be a limitation of the license? The reports work fine reading from that database for non encrypted columns Any advice would be appreciated Regards, Region : Australia East EncryptionKeyId : 09cba11c-1ddc-4c6e-8651-d8be0510055a EncryptionKey :
Power BI Report Server and Always Encrypted
Hi, Reading https://docs.microsoft.com/en-us/power-bi/report-server/always-encrypted-support I am still unsure where I need to put in the "Column Encryption Setting=enabled" in the connedtion string. At the bottom of this page where the connection sring is detailed a link is given which, when viewed, doesn't detail how to set the connection in relation to Power BI. Going through the data source set-up connection for a Power BI report to a SQL Server 2016 I don't see anywhere I can put this connection string command. Am I missing something? I feel I may need to put this in manually in the 'source' comand in the Advanced Editor of the Power Query Editor but any attempt I try always results in a Expression Error. Can anyone please guide me to how to go about setting up the encrypted connection? Thanks