Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |