I have a database encrypted in my SQL Server instance. To be specific,I used the feature 'Always Encrypted' to encrypt two columns from that database. This database has a relation with a database with the same data in my SSAS I know that SSAS decrypt the data in order to analyis the data but I need to have a connection using PowerBI to that database in SSAS but due to the decryption process in SSAS I get the columns that needed be encrypten in text plain and visible for me.

Do you know how to have a connection using Power Bi to SSAS database but keeping the columns encrypted?

thanks in advance

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.