Forum Discussion
Encryption
Hi all, I have a doubt related to encrytion. In my company they want to encrypt some sensitive information columns, we have different databases but we created pipelines and all the information is...
Hi susanalopezaria , Thank you for reaching out to the Microsoft Community Forum.
You can encrypt sensitive data in BigQuery, but in Power BI those columns won’t be very usable. Power BI can load them, but it can’t decrypt them, so they don’t work properly for relationships, filters or calculations, they’re just treated as opaque values. If you need those columns for joins or filtering, they must be made usable before they reach Power BI. If decryption isn’t allowed, then avoid using them directly and instead use things like hashed keys or masked values.
So, for your filter question, no, you can’t decrypt inside Power BI, which means encrypted columns won’t work properly in slicers unless they’re already transformed upstream.