Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Decrypt Column in Power Query from Snowflake

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

Data Protection
Need Help

5 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

    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's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      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.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    3 years ago

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