Create Parameter for query in M code

[vmamontov]

Hi all!
If there any possibilities to create Query Parameter from my custom connector's code ?

[v-jingzhang]

Hi @vmamontov 

The following documentation may be helpful. 

The ‘Get Data’ User Experience in Power BI / Power Query — The Power User

DataConnectors/function-docs.md at master · microsoft/DataConnectors · GitHub

In the second link, it says "Power Query will automatically generate an invocation UI for you based on the arguments for your function. By default, this UI will contain the name of your function, and an input for each of your parameters." So try defining variables in your functions and use them in your codes just like using parameters. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.