Forum Discussion
Password.Type Usage in M Query Language
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.
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.
4 Replies
- lbendlin
Super User
It's a text format field where the text is not visible.
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.
- 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], {})))
