Forum Discussion
J_Mug
Helper I
Helper IDecrypt string values (AES256) from a column of a table in a query
HI, I want to decrypt string values from a crypted column on a table imported as a query in my Power BI report. The string is crypted in AES256. How can I do in Power Query to decrypt in a new...
AlexisOlson
Super User
Super UserI don't think there's a native implementation for AES256 in Power Query.
This leaves a few options:
- Decrypt before loading into Power BI (e.g. with SQL).
- This is probably the simplest approach.
- Use a Python or R script within Power Query.
- Both of these languages should have packages/libraries for AES.
- Write your own decryption implementation in M (or hire someone else to).
- Possible but not really advisable. I've done this sort of thing with SHA256 but wouldn't feel comfortable using my own implementation for production purposes.
Hello how can we use Python since Power bi service do not support the Crypto library as for R digest library isn't working correctly for my case