Is it possible to use R Script Encryption method to add a new column to a table.

[HavenerTed]

Hello,

I have been working on adding extra security to a website my organization is working on and we have set up a deep link based on two columns in a Power BI table with a URL attached. However, the security team asked to create an encypted URL so an ID cannot be modified by a user in the URL to take them to a page they are not supposed to.

I  worked with an R developer and he has a method of encrytpion that works in CSV files but I do not want to rewrite a source I just want to add a column in Power BI. 

In Power Query, the R Script I wrote seems to work but I receive the following error when testing on a dummy data file:

This is the script I used:

Here is the dummy data columns:

This is just a test to see if we can even make it work in our actual database.

Please let me know if I am writing the script incorrectly or if the format is just not possible to read into Power Query.

Thank you

[rubayatyasmin]

Hi, @HavenerTed 

I found a similar thread that might be helpful

https://community.fabric.microsoft.com/t5/Desktop/DataFormat-Error-We-cannot-convert-this-value-from...

[HavenerTed]

Hello, I visited this thread previously and it did not assist. The team is finidng an alternative way of encyrption.