I am attempting to use encrypted columns in my SQL Server database as output for a PowerBI dataset.

I set up ‘Always Encrypted’ to encrypt the data in my SQL Server Database. I would like to load the encrypted column into PowerBI without decrypting the data.

I have managed to load the data, but the encrypted strings do not look the same in the PowerBI dataset as they do in SQL Server:

PowerBI:

I would like to present the output just as it looks in SQL Server. Is this easy to do? Any advice would be appreciated.

Thank you