How to get a value from user input using MQuery and Visual Studio

[vikas-jk]

Hello,

As I am new to MQuery, I would like to know how can I get a custom input value from user when creating Custom Connector for Power BI using Visual Studio and MQuery.

Like we ask for user credentials using

CheckHeaders = [
    Authentication = [
        UsernamePassword = [
            UsernameLabel="companyid",
            PasswordLabel=" privatekey",
            Label="API User Credentials"]
    ],
    Label = "Manage"
];

How Do i add a new input value Like "last page number" which I need to pass to CheckHeader.Content and get it from user?

Need MQuery code, thanks.

[lbendlin]

Power Query does not allow support user input. You can try with R script as one of the transforms but I doubt that will work on the Power BI desktop. It definitely will not work on the service.

[vikas-jk]

So, There is no way to get Custom user value, like we get OAuth values in Custom Connector as shown below

Username=Extension.CurrentCredential()[UserName],
Password=Extension.CurrentCredential()[password]

What If I want to limit the number of page call, when I am calling api which has more than 500 pages ( 25 records per page )and I need only first 10 pages?

[lbendlin]

use a different tool for the API calls.