Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
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.

GrayMarshUK

Paginated Report Builder - Cannot Allow Null for a Multi Value Parameter

Submitted by on ‎03-30-2023 12:53 AM

In the Parameter Properties in a Paginated Report if Allow null value and Allow multiple values are set then it reports an error saying "A multi-value parameter cannot include null values'

 

Speaking with a Microsoft representative it was statetd that this could be a bug! 

Status: Investigating

Hi @GrayMarshUK ,

 

A multi-value parameter cannot include null values. When deselecting option "Allow blank value ("")", Report Builder shows error "Please enter a value for the parameter 'XXX'. The parameter cannot be blank."

 

And remeber Use white space (' ') instead of empty string ('') as a label.

For original post ,you may refer to Issue with Paginated Report Optional Parameters (A... - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎03-30-2023 11:13 PM
Status changed to: Investigating

Hi @GrayMarshUK ,

 

A multi-value parameter cannot include null values. When deselecting option "Allow blank value ("")", Report Builder shows error "Please enter a value for the parameter 'XXX'. The parameter cannot be blank."

 

And remeber Use white space (' ') instead of empty string ('') as a label.

For original post ,you may refer to Issue with Paginated Report Optional Parameters (A... - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses