Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello every body,
I'm fairly new to Power BI and I am focused on data analytics therefore technical issues are way out of my reach.
I am trying to link my PowerBI to our DB which is hosted on local server and can only be accessed with a VPN.
Plus we have an "email address" column that is encrypted for security purposes however I need it decrypted when I use powerBI.
Is there any kind of solution to my issue ?
We were thinking about getting around the problem and making a program by ourselve that would automatically uploads the tables (9 in total) decrypted (CSV format) on a cloud based folder. However it would be much easier if I could plug it directly to Power BI 🙂
Solved! Go to Solution.
@Anonymous,
Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?
Regards,
Lydia
@Anonymous,
How about you write SQL statement to decrypt the column when importing data from postgreSQL database?
About how to decrypt column in postgreSQL, please review the following similar thread.
https://stackoverflow.com/questions/26656910/pgp-sym-encrypt-and-decrypt-an-entire-column-in-postgresql
Regards,
Lydia
Thanks for your answer I had seen this post but it did not work for me 😕
I will precise my issue:
We are using Jasypt lib to encrypt data and PBEWithMD5AndDES algorithm
We have installed pgcrypto extension and tried to call that function on encrypted column, but it did not work.
If you have a solution for me that would be amazing!
@Anonymous,
Are you able to decrypt the column in other postgreSQL GUI tool by writing the SQL statement?
Regards,
Lydia
Hey @v-yuezhe-msft, thanks for your help !
No we use pgcrypto and try to decrypt PBEwith MD5 & DES but we can't via SQL it says :
ERROR: Unsupported cipher algorithm
********** Error **********
ERROR: Unsupported cipher algorithm
SQL state: 39000
We don't understand why but it feels like we will have to change encryption...
Leonard
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.