Forum Discussion

Mister3m's avatar
Mister3m
New Member
4 years ago

Show unencrypted Data in PowerBi Desktop - Always Encrypted feature from SQL-Server

Hi, we are using the Always Encrypted (AE) feature in SQL-Server on premise. In Management Studio and also in Visual Studio it works quite well, I mean displaying encrypted data if you have the certificate (local windows certificate store). We are now integrating PowerBI to analyse the data and we are unable to find a setting to display the encrypted column(s) data in plain text. Which setting in PowerBI Desktop or in the ODBC driver do I have to make so that unencrypted data is displayed?

All applications are on premise und in PowerBI we can not use Import Query, because we want to analyse a big database table.

Greetings Klaus

 

If I am using the integrated SQL-Server driver

 

 

If I am using the new ODBC driver 17 for SQL-Server

 

Need Help

2 Replies

    • Mister3m's avatar
      Mister3m
      New Member
      4 years ago

      Thank you for the link. But this article only describes the configuration in connection with an Azure database. We need the ODBC setting for onpremise to the Windows Certificate Store.
      I still found that if I am entering the connection call directly in the options, I am getting the data displayed decrypted (perfect), but the query changes from direct query to import query. I cannot find an option in the ODBC driver to activate the direct query mode. How am I supposed to import terabytes of data into PowerBI if the user has to set the appropriate filters in the ReportServer for his individual analysis?

       

      data source=>Servername<;initial catalog=>Databasename<;integrated security=True;application name=>Servername;Databasename<;column encryption setting=Enabled