Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Report Builder parameter search not working without (3) leading spaces

I noticed this while trying to do a parameter search on one of our paginated reports in the server. In our (raw) data, the available values in the parameter do not contain leading (or trailing) spaces.

 

Example: When searching for the term "ASEAN" (without leading spaces), no items returned:

02.png

 

Same keyword but with 3 leading spaces: "   ASEAN"

03.png

Status: New
Comments
v-chuncz-msft
Community Support

@olimilo 

 

I cannot reproduce the issue. Check the data souce again and create a support ticket for assistance if necessary.

 

olimilo
Responsive Resident

I was recently able to find a solution to this. In the Parameter Properties > Available Values, instead of using ParameterCaptionIndented as the Label field, you need to select ParameterValue as the Label field value:

 

2021-10-28 10_31_28-Report Parameter Properties.png

As to why ParameterIndentedValue is the default selection in this property, I would not know. I think it would be better to just have ParameterValue as the default selection instead.