topic Re: Put parameter to the link in Power BI server paginated report in Report Server

Put parameter to the link in Power BI server paginated report

finch4er — Wed, 28 Sep 2022 06:31:09 GMT

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

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

Re: Put parameter to the link in Power BI server paginated report

v-alipat — Wed, 28 Sep 2022 23:14:12 GMT

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)

Re: Put parameter to the link in Power BI server paginated report

d_gosbell — Thu, 29 Sep 2022 07:47:50 GMT

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

Re: Put parameter to the link in Power BI server paginated report

DmitryKo — Fri, 30 Sep 2022 07:48:33 GMT

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

Re: Put parameter to the link in Power BI server paginated report

d_gosbell — Fri, 30 Sep 2022 07:50:37 GMT

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.

Re: Put parameter to the link in Power BI server paginated report

DmitryKo — Fri, 30 Sep 2022 08:03:11 GMT

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.

Re: Put parameter to the link in Power BI server paginated report

Brian_Hunt — Thu, 07 Sep 2023 17:07:30 GMT

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

Re: Put parameter to the link in Power BI server paginated report

v-alipat — Thu, 07 Sep 2023 20:38:33 GMT

Glad to help! 😊