Variable of password type in power query

[Anonymous]

I need to pass a variable of type password to a function, which reflects a login - kind form

How to create a variable of password type in power query?

Any suggestions ? Thanks!

[v-qiuyu-msft]

Hi @Anonymous, 

Which data source do you want to get data from? 

If using web data source, you can refer to this similar thread: https://social.technet.microsoft.com/Forums/en-US/11d4347c-0332-4dea-b270-a2dcd911c8b0/passing-username-and-password-in-basic-authentication?forum=powerquery

Best Regards,
Qiuyun Yu

[Anonymous]

Hi  @v-qiuyu-msft,

Thanks for the reply.

I am already getting the data from REST API source, no issue with that.

The simple issue is I have built a custom login form with text fields. Among them Username and password is also present, which is of text type.

How can I encode the raw text in password field using power query, like you have seen in other login forms.

Do I have some data type close to password type, just like we have text type?

Please find attached screenshot:

Thanks!password

[salem_wafi]

It is suppose to be "Password.Type" but for some reason it doesn't work unfortunately.