Passing blank parameter to Embed report not working

Hi czs ,

Thank you for posting in this community.

Currently this is by design that we cannot use the URL query string parameter to filter null or blank

As a workaround, we can use the following syntax to create a calculated column to check if the original column is null:

Column = IF(LEN('Table'[String])>0,"NotBlank","Blank")

Then we can filter the embed report with the new created column as shown below:

&filter=Table/Column eq 'Blank'

Or you can simply replacing the blank values to text "Blank", and then try Filter=TableName/ColumnName eq 'Blank'

Similar issue for your reference:

Solved: Parameter filter in url when looking for "BLANK" v... - Microsoft Fabric Community

Best Regards,

Joyce,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.