Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
How can we encrypt any column in Microsoft fabric Lakehouse using purview.
Hi @Anonymous ,
Thanks for the reply from bharatmoghe .
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
To encrypt a column in Microsoft Fabric Lakehouse using Purview, follow these steps:
Identify and Classify Sensitive Data: Use Purview to scan the Lakehouse, classify sensitive columns, and apply sensitivity labels like PII or Confidential.
Define Encryption Policies: Leverage Purview to guide encryption decisions and use Azure Key Vault to manage encryption keys securely.
Encrypt Columns: During data ingestion or transformation, apply encryption using tools like PySpark or Synapse. For example, hash sensitive data with SHA2 or similar methods.
Govern Access: Set access policies in Purview to ensure only authorized users can view or decrypt the encrypted data. Use Purview insights for compliance monitoring.
Manage Keys Securely: Store and rotate encryption keys in Azure Key Vault, integrating them into your pipeline workflows.
Validate and Audit: Test access controls and use Purview's reporting to ensure encryption aligns with compliance requirements.
User | Count |
---|---|
68 | |
38 | |
15 | |
14 | |
5 |
User | Count |
---|---|
73 | |
64 | |
25 | |
8 | |
7 |