Password.Type Usage in M Query Language

[salem_wafi]

Hi,
While developing my M code in the Advanced Query Editor I noticed there is a property that have been suggested to me automatically called "Password.Type" please see attached images.
Does anyone knows what is the purpose of it? I googled about it a lot but with no luck.

[salem_wafi]

Thanks @lbendlin and @Anonymous 
but for some reason that type won't work! Do you have any idea?

[lbendlin]

You can't use it like that. Password.Type is not an actual type, it is a facet of type text.

Power Query M Primer (Part 17): Type System II – Facets | Ben Gribaudo

You can test this by running 

Table.SingleRow(Table.Schema(#table(type table [a = Password.Type], {})))

[lbendlin]

It's a text format field where the text is not visible.

[Anonymous · Accepted solution]

Hi @salem_wafi ,

You can click on the exclamation mark to see the function. The type that represents a text password.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.