Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BDolphin
Helper I
Helper I

Paginated URL Report Parameters with an & sign

Is there any kind of workaround for the Paginated URL Report Parameters if your parameter option has an & sign in it, for example B&E?

 

 

2 REPLIES 2
v-xicai
Community Support
Community Support

Hi @BDolphin ,

 

The format for a multi-value parameter is to repeat the parameter name for each value. For example, the following URL example includes a multi-value parameter "Salesperson”.

 

https://app.powerbi.com/groups/me/rdlreports/xxxxxxx-abc7-40f0-b456-febzf9cdda4d?rp:Salesperson=B&rp...

 

You may refer to the articles:

Pass a report parameter in a URL for a paginated report in Power BI

 

URL parameters in paginated reports in Power BI

 

Best Regards,

Amy

 

Community Support Team _ Amy

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

@v-xicai  I think you misunderstood, I am not trying to pass multiple parameters, I am trying to pass a single parameter that has an & in the middle of it. The single parameter is "B&E". I've already used the links provided, the report opens with every other parameter value selected, it just won't work when I select "B&E". I would really prefer not to have to change the field value if I can get away with it, which is why I was hoping there might be some kind of trick or workaround. 

 

Thanks, 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors