Forum Discussion
Paginated Reports Back Navigation Fails When Multi-Value Parameter Uses Select All
Hi all, Recently, I’ve been investigating an issue in Power BI Paginated Reports where I encounter a problem when navigating back to the main report from a subreport after using the “Select All” opt...
What’s happening is that Select All is not stored as the full explicit list of values. When you navigate to the subreport and then use the Back button, Report Builder tries to re-validate the parameter using a stale or incomplete value set, which causes the validation error. When you manually select values, the parameter contains an explicit list, so validation succeeds.
Practical workarounds:.
Use a custom “All” value (e.g. -1) and handle it in the dataset query instead of the built-in Select All.
Convert the parameter logic to explicitly expand “All” into all values in the dataset.
WHERE
(
@MyParam = '-1'
OR MyColumn IN (@MyParam)
)