Forum Discussion
Issue with Paginated Report Parameter Defaulting to NULL
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
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
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.