Forum Discussion

Narukkp's avatar
Narukkp
Helper V
5 years ago
Solved

URL Parameters expression for Multi selection parameters in report builder

Hi Team,   Below expression is working as expected when parameter having single selection but when parameter selecting multi value it is not working as expected. It is not passing the multi selecti...
Need Help
  • Narukkp's avatar
    Narukkp
    5 years ago

    Hi Team,

    I got the solution. We need to give expression like 

    Dim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')

Narukkp's avatar
Narukkp
Helper V
5 years ago

Hi Team,

Any one having idea about how to pass the parameter selected multivalues from report builder to power bi detail report using url action 

 

Narukkp's avatar
Narukkp
Helper V
5 years ago

Hi Team,

I got the solution. We need to give expression like 

Dim_Corp_Hier/Cur_Area_Nbr in ('" & Join(Parameters!Area.Value,"','") & "')

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Narukkp , Thanks for sharing. Kudos to you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi.
    Even I am trying to create a paginated report and trying to pass url parameters from my power BI report. In my case i have about 6 slicers in my Power BI which needs to be passed to my paginated export. Slicers selection could be more than 1 value based upon user selection criteria.

    I see that you have already implemented this logic. Can you please share with me your sample pbix and rdl.

    Thanks.