Using crypto functions for a custom connectors

[rcyber]

Hi All!

I'm trying to create a custom connector for Power BI desktop.
I'm connecting to the site that requires special encrypted headers.
I need to merge the current timestamp and private key into one string. Then I need to encrypt this string using Base64 algorithm.
Is it possible? How can I do it using Visual Studio 2017 and Power Query SDK?

Thanks in advance,
Alexander.

[v-yuezhe-msft · Accepted solution]

@rcyber,

You can use Binary.ToText() function. There is a similar thread for your reference.

https://community.powerbi.com/t5/Desktop/Encode-a-Text-field/td-p/440197

Regards,

Lydia