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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Navsharma
New Member

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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