Issue with Paginated Report Parameter Defaulting to NULL

[Riskworks114]

Hi everyone,

I’m having a problem with a paginated report in Power BI. I have a parameter that allows NULL values, but the issue is that the parameter defaults to NULL even though I haven’t set a default value for it.

Has anyone else experienced this? How can I stop the parameter from defaulting to NULL?

Thanks for your help!

Power BI Report Builder Version
15.7.1813.16

[Anonymous · Accepted solution]

Hi @Riskworks114 ,

The parameter may default to NULL if no other default value is specified, as it allows NULL values. You can refer to the following official documentation to set a custom default value for the parameter.

Add or modify default values for a Power BI paginated report parameter - Power BI | Microsoft Learn

Best Regards

[Riskworks114]

An issue that arises with the defaulting to NULL is that the report will run automatically with the NULL parameter(s).  Adding a stop gap default, say a string or blank space will allow the report to run automatically as well. This behavior can result in large data requests for unsuspecting users.  Not certain what the real solution is here, outside of an additional dropdown parameter that needs to be set prior to the report query firing.  Thoughts?   Thanks.