Issues with Paginated Reports

[swikritee_p]

I have created a paginated report using an existing PowerBI dataset. I have created parameters to pass the slicer values from the report but the select all options is not working, even when we have defined the relevant field in the default and used mutli-select in the parameter.

Also on trying to drill through from PowerBI report to another page which has the Paginated Report, it is not showing all the data even on downloading the paginated report.

[Anonymous]

Hi  @swikritee_p ,

 you may need to check the following things:

• Make sure that the parameter in the paginated report has the Allow multiple values option checked.
• Make sure that the parameter in the paginated report has a default value of All or a similar value that matches the query for the dataset.
• Make sure that the query for the dataset in the paginated report has a condition that handles the All value or uses an IN operator to filter by multiple values.

Best regards.
Community Support Team_Caitlyn

[swikritee_p]

Hi, we are already doing all the above mentioned steps and still facing the same issue.