Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
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?
use a different tool for the API calls.