topic Re: How to get a value from user input using MQuery and Visual Studio in Developer

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

vikas-jk — Sun, 12 Jul 2020 12:06:17 GMT

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.

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

lbendlin — Sun, 12 Jul 2020 18:22:51 GMT

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.

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

vikas-jk — Mon, 13 Jul 2020 17:12:47 GMT

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?

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

lbendlin — Mon, 13 Jul 2020 17:51:15 GMT

use a different tool for the API calls.