Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Nav Table with parameter-driven functions - any way to allow users to enter parameter at preview?

Hi - I'm working on building a custom connector with the SDK. For nav tables that contain functions - is there a way to allow users to enter values for required parameters at the first data  preview...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I found a solution in this very excellent reference SDK project:

    https://github.com/migueesc123/PowerBIRESTAPI

     

    focusing in on the 'functions' nav table has exactly what I was looking for:

     

     

     

    Hoping this saves sometime time in the future... I spent days trying to figure this out and finally this saved me.

jaweher899's avatar
jaweher899
Icon for Impactful Individual rankImpactful Individual
3 years ago

To allow users to enter values for required parameters in a custom connector using the Power BI SDK, you can use the setDefaultValue method on the DataParameter object in your DataSource.ts file. This allows you to set a default value for the parameter that the user can then change in the first data preview dialog.

Here's an example:

const myParameter: DataParameter = {
name: "My Parameter",
dataType: DataType.String,
};

myParameter.setDefaultValue("Default Value");

this.dataSource.dataParameters.push(myParameter);

 

In this example, the parameter myParameter is created with a name of "My Parameter" and a data type of DataType.String. The setDefaultValue method is then used to set the default value of the parameter to "Default Value". Finally, the parameter is pushed onto the dataSource.dataParameters array.

This will display a prompt for the user to enter a value for the parameter when they click "Load Data" in the first data preview dialog.