Forum Discussion

MarkSL's avatar
MarkSL
Helper V
6 years ago
Solved

Paginated Report - Using URL Parameters and Select ALL

Hi all, Our users require the option to download what they are seeing in a Power BI table into Excel. Rather than allowing them to use the Export Data into CSV option, we would prefer to give them a...
Need Help
  • MarkSL's avatar
    MarkSL
    6 years ago

    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.

MarkSL's avatar
MarkSL
Helper V
6 years ago

Hi audministrator 

Thanks for the input and the guide.  However my Paginated Report does already have this functionality - please download the example rdl file I supplied.  When you run the report you will see there is a dropdown called Site.  Here I can successfully select one, a few or Select All and the report works.

 

The query is, here can I select all values when calling the Paginated Report from my Power BI report, using the URL Parameters.  The Guy in a Cube video, demonstrates with just a single value being supplied.  However you can concatenate the values together, but there is a limit before the URL fails.  I am hoping there is a way, using URL Parameters, to 'Select All' and not have to pass seventy, eighty individual values in the URL string.

 

Thanks

 

Mark