Forum Discussion
RaBu78
9 months agoNew Member
Custom BI Connector - Create UI parameters dynamically
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
I want to create the parameters for the UI dynamicallyI don't think you can do that. Parameters need to be static.
3 Replies
- lbendlinSuper User
I want to create the parameters for the UI dynamicallyI don't think you can do that. Parameters need to be static.
- v-venuppuCommunity Support
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.