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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Navsharma
Frequent Visitor

How to pass parameter in embedded report in the application

I need to pass parameters into the URL to the embedded report. Any link that helps for step by step process.

2 REPLIES 2
v-huijiey-msft
Community Support
Community Support

Hi @Navsharma ,

 

To set report parameters within a URL, use the following syntax:

rp:parameter=value

 

For example, to specify the two parameters "Salesperson" and "State" that are defined in a report in My Workspace, you would use the following URL:

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

 

To specify the same two parameters defined in the report in your app, use the following URL:

https://app.powerbi.com/groups/me/apps/xxxxxxx-c4c4-4217-afd9-3920a0d1e2b0/rdlreports/xxxxxxx-639e-4...

 

To pass a Null value for a parameter, use the following syntax:

parameter:isnull=true

 

For example,

rp:SalesOrderNumber:isnull=true

 

To pass a Boolean value, use 0 for False and 1 for True.

 

To pass a floating point value, include the decimal separator for the server locale.

 

If a report contains a report parameter that has a default value, and the value of the Prompt property is false (that is, the Prompt User property is not selected in Report Manager), you cannot pass a value for the report parameter in the URL.

 

For more detailed examples and syntax, please refer to the official documentation:

Pass a report parameter within a URL for a Power BI paginated report - Power BI | Microsoft Learn

 

If you have any further questions please feel free to contact me.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

I found that we can't pass the parameters value in URL due to security purpose. https://learn.microsoft.com/en-us/javascript/api/overview/powerbi/embed-paginated-report speaks about parameters but I am not getting how to implement the same. 

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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