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.

audministrator's avatar
audministrator
Frequent Visitor
3 years ago

Hi,

From remote it's hard to figure out what is going wrong ?

 

But did you get all the settings an correct in your report to build the proper parameter settings?

I definitely can recommend this video (if you have not seen it yet) on how to get started to make sure all settings are correct.

https://www.youtube.com/watch?v=XA5twJ2wLd0

Once you have the parameter dataset correct in your report, you can run a query on the HIDDEN PARAMETER DATASET to further debug the isseu.

 

 

 

 

Ikram_5's avatar
Ikram_5
New Member
3 years ago

Actually I have a problem when passing the URL parameters from my dashboard in power bi desktop to my paginated report in Power BI service