Forum Discussion

Arranafc19's avatar
Arranafc19
Helper IV
5 years ago

Power BI using encrypted columns in Azure Database

Hi    I am wondering if anybody could provide me some information on if it is possible to pull encrypted columns into power bi datasets.   I am currently using an azure sql database as a datasour...
Data Protection
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Arranafc19 

It is not possible to read decrypted data in Power BI. After you import the encrypted fields into Power BI, you will not be able to see these fields in Data view unless you transform the binary columns to text columns in Query Editor of Power BI Desktop, but please note that the text columns still contain encrypted data.

See this similar thread.


If you need to read decrypted data in Power BI, you would need to firstly decryped the fields in SQL Server , and then import data to Power  BI.

For reference: Encrypted Fields in Table of Sql Server Database.

 

Best Regards,
Rico Zhou

 

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