Custom BI Connector - Create UI parameters dynamically

[RaBu78]

Dear all,

I'm developing a custom BI connector and I can show input parameters (e.g. date) in this here:

I do this via this code in M:

       let        

                dataFunction = (param1 as any, optional param2 as any) as table =>
                    GetData(actions, params, {param1, param2}, serverUrl),              

   
                typeParam = type function (
                    param1 as (type date meta [
                        Documentation.FieldCaption = "Start Date",
                        Documentation.FieldDescription = "Start of time range",
                        Documentation.SampleValues = {#date(2024, 1, 1)}
                    ]),
                    optional param2 as (type date meta [
                        Documentation.FieldCaption = "End Date",
                        Documentation.FieldDescription = "End of time range",
                        Documentation.SampleValues = {#date(2024, 12, 31)}
                    ])
                ) as table
         
            in
                Value.ReplaceType(dataFunction, typeParam)

That works without any problem :).

So now the problem is: I get a parameter list via json with each entry like [ Name = "StartDate", Type = "type date", IsOptional = "false"... ] and I want to create the parameters for the UI dynamically by the data of the parameter list. That means the parameter count is not the same, the parameter types are not always the same and the optional parameter can be different. How can I create the UI parameter inputs by the definition of the json.

Does anybody have a solution for this?

Best regards

Rainer

[v-venuppu]

Hi @RaBu78 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @RaBu78 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[lbendlin · Accepted solution]

I want to create the parameters for the UI dynamically

I don't think you can do that. Parameters need to be static.