Decrypt Column in Power Query from Snowflake

[Anonymous]

Hi

I have encrypted a column called [ENCR_NOTE] in Snowflake using the encrypt built in function.

I have loaded the data in Power Query and I m trying to now decrypt it.

How can I decrypt them please? I know the passphrase and want to decrypt them in Power BI.

Please help

[lbendlin]

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

[Syndicate_Admin]

Thank you! Could you please tell me more or point me to the article that will help me?

[Syndicate_Admin]

Yes it is select *, to_varchar(decrypt(encr_note, 'xxxx'), 'utf-8') notes 
from finrep_dev.treasury.cash_balance_fact_encr_pbi

And I have now managed to decrypt them . The challenge for me now is to manage to decrypt with a passphrase. Please help me with that...any ideas?

[lbendlin]

You can use parameters to supply the passphrase. Obviously that is not safe. You could also store the passphrase elsewhere like a SharePoint document library with restricted access. Doing that will likely result in issues with the formula firewall.

[lbendlin]

Do you know the algorithm too?