Paginated Power BI Report

[hs28]

Hi,
We’ve created a Paginated Report using the existing semantic model of a Power BI report. This Paginated Report was built in the Power BI Service and embedded as a visual on the second page of the existing Power BI report.
Here’s how the setup works:
Page 1 of the Power BI report: Displays the data in a table format and uses slicers for filtering.
Page 2 of the Power BI report: Contains the Paginated Report, which uses the slicers on Page 1 as parameters.
Everything functions as expected: the slicers on Page 1 are synced with the parameters on Page 2. However, we’re encountering an issue where one specific value from one of slicers isn’t being passed correctly as a parameter to the Paginated Report.
All other slicer values sync perfectly, but this one value always fails to work as expected. We’re unsure what might be causing this issue and would greatly appreciate any insights or suggestions.
Thank you in advance!

[rajendraongole1]

Hi @hs28 - can you check if the problematic slicer value exists exactly as it appears in both the Power BI report and the Paginated Report dataset. Even minor differences in spelling, spaces, or casing can cause issues.If your dataset has different sources or transformations, verify that this value isn’t being altered before being used as a parameter.

check if the parameters are associated with slicers, Set to accept multiple values if it should.Using the correct data type (e.g., text vs. integer).Fetching values correctly from the dataset.Adding a filter to remove blanks in Power BI.
Using IF(ISBLANK([Field]), "N/A", [Field]) in DAX to replace nulls.

Since parameters are passed via URLs in the embedded Paginated Report, certain characters (&, %, /, etc.) might break the URL encoding.
If your problematic value contains special characters, try renaming it temporarily (e.g., replacing spaces with underscores) and see if that fixes the issue.

[Anonymous]

Hi @hs28 

I did some tests on your question:

Create a report on the desktop and upload it to the service

Use the semantic model of the above report to create a paginated report on the service, and use the country and date fields of the above report as parameters of the paginated report

Embed the paginated report in the service

Set the synchronization slicer on the service

Can be synchronized to page2 normally

This forum is for discussion of Power BI Desktop. If you need more help, you can ask questions in the following link, where more professional engineers can help you:

Report Server - Microsoft Fabric Community

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.