Power BI Deskteop with embedded Paginated report having an issue with report header parameters

[jrubino77]

We have created several Report Builder Paginated reports to run on our On-premise server.

Since then, we have been converting these into the Power BI Desktop (embedding them).

The original Paginated reports were created using text boxed with what was filtered by the parameter selections.  When running the PBI Desktop version with the report embedded it is not working the same way.  

I am attached 2 screenshots of what I am talking about.  

The First screenshot is the Power BI Desktop published to the Cloud shows RED arrows pointing to the text areas where values are printing that were not selected and the BLUE boxes show the area where selections for SO Number.

The Second one is the Paginated report working correctly when selecting several SO Numbers (RED rectangles showing them).

Any help that anyone can give in documentation on how to do this in a better way. 

Expression for the text code for SO Number - = Iif(

 Parameters!SONumber.Count = Count(Fields!Sales_Order__.Value, "SONumber"),

 "All SO Numbers", " = " & Join(Parameters!SONumber.Value, ", "))

The first 

Power BI Desktop with Paginated report on Cloud ServiceReport Builder on Server

[Anonymous]

Hi @jrubino77

Based on the information you provided, it appears that your parameter value settings in the paginated report are correct and working correctly when selecting multiple SO numbers in the second paginated report.

The possible cause is that the parameter mapping in the Power BI report is not working properly.

You need to make sure that the fields used in the slicer are related to the fields used in the paginated report parameters.

You can check this by clicking the paginated report visual in Power BI Desktop and going to the Format pane.

Then, go to the Parameters section and verify that the fields are mapped correctly.

You can view the link below for more details:

Embed paginated reports in your Power BI embedded analytics application - Power BI | Microsoft Learn

Regards,

Nono Chen

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