Skip to main content
Microsoft Idea

Power BI

New

Pipelines deployment settings shall list available options when configuring the parameters

Vote (1) Share
Pär Adeen's profile image

Pär Adeen on 22 Jul 2021 21:40:15

E.G. for the code below that defines two parameters (Parameter1 and Parameter2), the user gets no options in the Deployment Settings.

As both parameters has the options "One", "Two", and "Three", the user should have been given the options. Not having the capability of giving options opens up for mistakes when configuring the parameters.



Using Power BI Desktop, both parameters has the predefined options:

 


section Section1;

  shared List1 = let Source = {"One", "Two", "Three"in Source;

  shared Parameter1 = "Two"

    meta [

      IsParameterQuery         = true,

      ExpressionIdentifier     = List1,

      Type                     = "Text",

      IsParameterQueryRequired = false

    ];

  shared Parameter2 = "One"

    meta [

      IsParameterQuery         = true,

      List                     = {"One", "Two", "Three"},

      DefaultValue             = "One",

      Type                     = "Text",

      IsParameterQueryRequired = true

    ];