Forum Discussion
Paginated Report - Using URL Parameters and Select ALL
Ok, after much investigation and great support from Microsoft, we found the solution and it was dead simple!
Set the paginated report up so all parameters are loaded with Default values from the dataset. And then for the URL string passed from the calling Power BI report, only reference a parameter if the user has actually selected a value from a slicer. If the user has selected no values from any slicers (eg Select All), then simply submit the default Paginated Report URL string. If a user has selected a value from a slicer, then modify the URL to include a reference to that particular parameter and its selected values.
Ok, after much investigation and great support from Microsoft, we found the solution and it was dead simple!
Set the paginated report up so all parameters are loaded with Default values from the dataset. And then for the URL string passed from the calling Power BI report, only reference a parameter if the user has actually selected a value from a slicer. If the user has selected no values from any slicers (eg Select All), then simply submit the default Paginated Report URL string. If a user has selected a value from a slicer, then modify the URL to include a reference to that particular parameter and its selected values.
Hi MarkSL do you still work with that "workaround" by setting default values to parameters? I have the same challenge but in my scenario (cascading parameters) setting default is no option because the number of vlaues in the lowest level parameters are then to high.. really sh*t that there is no option to simulate the "all selected" via URL 😞