Forum Discussion
Decryption in Power BI
Hi All,
Is there any way to Power BI decrypt the data before showing on the reports? Any alternative? Does Microsoft have any plans to bring this feature in any future release?
Hi, vsutar123
Power BI itself currently does not support built-in decryption of encrypted data in its reporting capabilities. Data encryption and decryption is typically handled at the database or application level, not directly in Power BI.
There are several ways to implement decryption before displaying the data in Power BI:
You can decrypt the data in a SQL query using DECRYPTBYKEY or other SQL Server decryption functions, depending on how the data was encrypted. Here is an example using symmetric key encryption:OPEN SYMMETRIC KEY SymKey DECRYPTION BY CERTIFICATE CertName; SELECT CONVERT(varchar, DECRYPTBYKEY(EncryptedColumn)) AS DecryptedData FROM YourTable; CLOSE SYMMETRIC KEY SymKey;Create SQL views or stored procedures on the server that decrypt the data at the database level. Power BI will connect to these views or stored procedures and get the decrypted data.
This ensures that all sensitive operations (encryption, decryption) are handled securely in the database.Power BI is focused on visualization, and sensitive operations such as decryption should be performed securely in the database or through a custom middleware/API layer.
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
7 Replies
Hi, vsutar123
Power BI itself currently does not support built-in decryption of encrypted data in its reporting capabilities. Data encryption and decryption is typically handled at the database or application level, not directly in Power BI.
There are several ways to implement decryption before displaying the data in Power BI:
You can decrypt the data in a SQL query using DECRYPTBYKEY or other SQL Server decryption functions, depending on how the data was encrypted. Here is an example using symmetric key encryption:OPEN SYMMETRIC KEY SymKey DECRYPTION BY CERTIFICATE CertName; SELECT CONVERT(varchar, DECRYPTBYKEY(EncryptedColumn)) AS DecryptedData FROM YourTable; CLOSE SYMMETRIC KEY SymKey;Create SQL views or stored procedures on the server that decrypt the data at the database level. Power BI will connect to these views or stored procedures and get the decrypted data.
This ensures that all sensitive operations (encryption, decryption) are handled securely in the database.Power BI is focused on visualization, and sensitive operations such as decryption should be performed securely in the database or through a custom middleware/API layer.
If I have answered your question, please mark my reply as solution and kudos to this post, thank you!
i have encrypted data in snowflake can i decrypt in power bi service on the fly while i use direct query or can i achive by having udf at report server level .as of now i use cognos bi and snowflake encrypted data where i am creating udf to decrypt on the fly in cognos while using direct query .need same functionality in power bi can we do it with byok pls confirm
Data in Power BI is already encrypted. Are you referring to BYOK (Bring your own key) ?
