encrypted data

[Marvynb]

Hi all,

does anyone know if Desktop PowerBI can read and transform MySQL encrypted data yet?

[v-yuta-msft]

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

[Marvynb]

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

[v-yuta-msft]

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

[Marvynb]

Hi all,

does anyone know if PowerBI Desktop can read and transform MySQL encrypted data yet?