Different controls that can be used in custom connector using M Language

[rajulshah]

Hello everyone ,

Can anyone please guide me on how to show different controls on custom connector ( For eg : Checkbox, Radiobutton, Text Area, Expand/Collapse, Textbox with password type) using M language?

Also , it would be helpful if there's anything regarding how to pass parameters in textboxes or how to handle 'optional' datatype.

Any documentation or tutorial will be helpful on any one of these controls.

Thanks in advance.

[v-shex-msft]

Hi @rajulshah,

>>Can anyone please guide me on how to show different controls on custom connector ( For eg : Checkbox, Radiobutton, Text Area, Expand/Collapse, Textbox with password type) using M language?

Power query(M) not programming language, so you can't use it to customize your connector.

>>Also , it would be helpful if there's anything regarding how to pass parameters in textboxes or how to handle 'optional' datatype.

If you means define custom parameter as a optional parameter, you can define it with 'optional' prefix, then power query will recognize it as an optional parameter.

Sample:

let
    Source=(abc as text,optional option as number) => abc&option
in
    Source

Regards,

Xiaxoin Sheng

[rajulshah]

Okay , thank you @v-shex-msft! 

That means I won't be able to customize my custom parameter , right?

Although , can you please share where can I get tutorial of M language for custom connectors in Power BI?

Thanks a lot!

[v-shex-msft · Accepted solution]

Hi @rajulshah,

For custom connector, you can refer to below link:

Data Connector SDK Developer Preview

Regards,

Xiaoxin Sheng

[rajulshah]

Okay , thank you @v-shex-msft!

I am sure it will help me immensely.