URL link to Paginated Reports

[Anonymous]

Hi, It seems For Image--> Actions -->URL option is still not available for PBIRS (Jan 2019).

From PowerBIRS, I want a link to Paginated Reports using Button or Image. So how do I acheive this in Report Server ?

I do not want to display whole URL, instead 'Click Here', 'Data' as Title/Label because I have a plan to pass parameters to Paginated Reports.

[pdacheva]

Hi all,

I'm using the URL to Paginated Reports from my Power BI reports, but there is one thing I cannot make work and I can't figure out why. I want to pass a value to a Boolean parameter - I tried true/false, I tried 0/1, nothing works. The rest of my text/int parameters work fine, but the Boolean is being ignored. Has anyone managed to make Boolean ones work in URL?

TIA

[d_gosbell]

---

@pdacheva wrote:

I'm using the URL to Paginated Reports from my Power BI reports, but there is one thing I cannot make work and I can't figure out why. I want to pass a value to a Boolean parameter - I tried true/false, I tried 0/1, nothing works. The rest of my text/int parameters work fine, but the Boolean is being ignored. Has anyone managed to make Boolean ones work in URL?

---

Yes, it works fine for me passing in either true/false or True/False. If I try passing in anything else like 0/1 I get an error about the type being incorrect for the variable type being incorrect and if I alter the name of the parameter I get an error about trying to set a variable which does not exist. So I can't think how your url parameter would be ignored

[pdacheva]

Hi d_gosbell,

Thanks for your prompt feedback!

Actually I'm not sending URLs to a Report Server. I have a Power BI report published on the Power BI Service that redirects to a Paginated Report published on the Power bI Service as well. Probably that's where the issue is.

I tried with True/False and true/false, but nothing. I don't get error message, but the value is not passed (I try to pass False).

I'm not sure whether it's because I have a default value =true set to this Parameter, but again, for the rest of the Parameters I have, it works OK.

Thanks again!

[d_gosbell · Accepted solution]

---

@Anonymous wrote:

Hi, It seems For Image--> Actions -->URL option is still not available for PBIRS (Jan 2019).

---

The May 2019 (or later) releases have an option of WebUrl in the Action setting for images and buttons.

[Katie_L]

Hello @d_gosbell I see this post is pretty old, but maybe you can still help me out. 

Im trying to do the same (link into a paginated report), but cannt seem to get the URL correctly.

Actual PBI url: https://app.powerbi.com/groups/XXXXXX/rdlreports/XXXXXX?experience=power-bi

I tried adding my parameter at the end, since it already has "?experience"

https://app.powerbi.com/groups/XXXXXX/rdlreports/XXXXXX?experience=power-bi&luxk_parent_id=RP-1387

This got me into the report page, but not into the specific report.

Any help would be great. Thanks!

[d_gosbell]

This thread is based around the on-prem report server so the syntax is different. 

if that luxk_parent_id is a parameter it will need to be prefixed with rp: 

eg.

https://app.powerbi.com/groups/XXXXXX/rdlreports/XXXXXX?experience=power-bi&rp:luxk_parent_id=RP-138...

For the service you can use the url format outlined here URL parameters in paginated reports in Power BI - Power BI | Microsoft Learn - this doc includes 

[Katie_L]

Perfect, thank you!