encrypted columns not getting loaded in powerbi via odbc

[Anonymous]

We are uisng Azure DB and configured the DB as always encrypted. We are pulling the data from Azure DB to Powerbi via ODBC connection with SQL Server option. We have also implemented the Azure Key Vault and added the applications in AKV.

We have all the keys listed in AKV. Now when we connect to gateway VM and connect to powerbi dsktop it works fine. 

But if we connect to our local system and try to load tables it errors out with below error.

Failed to save modifications to the server.error returned with azure key vault failed to decrypt ECEK

While connecting to powerbi we are using odbc connection and we have configured gateway with same DSN as that of our system DSN. we are passing connection string with dsn=******;ColumnEncryption=Enabled;KeyStoreAuthentication=KeyVaultClientSecret; KeyStorePrincipalId=*****; KeyStoreSecret=***; **** has appropriate values,

[amitchandak]

Refer, if these can help

https://docs.microsoft.com/en-us/sql/connect/odbc/using-always-encrypted-with-the-odbc-driver?view=s...

https://social.msdn.microsoft.com/Forums/en-US/d689a59c-9943-411a-867b-39294af181ac/problem-using-ce...