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.
Hi all,
does anyone know if Desktop PowerBI can read and transform MySQL encrypted data yet?
Hi Marvynb,
Power BI can't decrypt the encrypted data by itself, but you can use R script lib(like Sodium) to decrypt or encrypt your data.
For more details about R script in power bi, please refer to:https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts.
Regards,
Jimmy Tao
Hi Jimmy Tao,
Thanks for the advice, im am new to R Scipting would you possibly be able to guide me in running a simple script as per below in R?
SELECT id,
cid,
id_number,
AES_DECRYPT(name, 'key' , ix) as Name,
AES_DECRYPT(surname, 'key' , ix) as Surname,
created_at
FROM database.table
Hi Marvynb,
About AES decryption in R, pleae refer to the offical documentation here:
https://www.rdocumentation.org/packages/digest/versions/0.6.15/topics/AES
Regards,
Jimmy Tao
Hi all,
does anyone know if PowerBI Desktop can read and transform MySQL encrypted data yet?
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.
User | Count |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |