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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
finch4er
New Member

Put parameter to the link in Power BI server paginated report

Hello !
I am trying to fill in field wtih parameter in Power BI server.
In service it works like ?rp:<some parameter>=xxx
But for server it is not working.

My link in Power BI server looks like 
http://powerbi.piece.net/Reports/report/Production/backward_traceability

finch4er_0-1664346105607.png

And I need to put only one parameter BC.

Idea is to go from other report directly by creation link.

 

Only way I found it is use ssrs link, which I can create by data feed in load menu.
I belive there is more beautifull way to do it 

7 REPLIES 7
d_gosbell
Super User
Super User

Power BI Report Server does not use the same style of URL parameters as the Power BI Service, it uses the SSRS style url parameters.

 

see: Pass a Report Parameter Within a URL - SQL Server Reporting Services (SSRS) | Microsoft Learn

and here URL access parameter reference - SQL Server Reporting Services (SSRS) | Microsoft Learn

This is surely not applies, since question is about Power BI RS and your links are about SSRS, no?


@DmitryKo wrote:

This is surely not applies, since question is about Power BI RS and your links are about SSRS, no?


It absolutely applies. Power BI RS is built on top of the SSRS engine.

Weird, since the pages you linked do not even mention rs:embed url parameter, which is probably the most, if not only, useful parameter for Power BI RS. At the same time, most of the parameters mentioned there, such as Section, simply do not work for Power BI RS.

v-alipat
Microsoft Employee
Microsoft Employee

Hello 

 

You should be able to do it like this: 

http://servername/Reports/report/reportName?parameterName=value

In your case, for example:

http://powerbi.piece.net/Reports/report/Production/backward_traceability?BC=value 

 

Please also note that you should use the parameter name, and not parameter prompt (they can be different) 

Almost every resource I found claims this isn't available in Report Server(on prem) but your solution worked. Thank you SO much!

 

Glad to help! 😊

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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