Connecting to SQL Server Always Encrypted data

[alongi]

I reviewed a similar post related to Azure SQL databases and the Azure Key Vault, our use case is an on-premise SQL Server, using the WIndows Certificate Store. We have a database that is using Always Encrypted functionality to encrypt PII. We need to access the decrypted data in Power BI. We have a power platform gateway connnecting to Sql on-prem. Does anyone have a recommended approach for our use case, thanks

[GilbertQ]

Hi @alongi 

The only thing that comes to mind would be is to install the certificate on the gateway server, which should help.