cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mogry
Advocate I
Advocate I

Link to another report using Built-in Collections (global variable)

Hello Community,

 

On SSRS the global variable for the server URL is working fine, but in PBIRS not. I found this MS documentation  and like to know if and where these built-in references can be edited.

 

My example:

Link to the report: http://dev-kpl-pbi-vm/Reports/report/test_report 

[&ReportServerUrl] is giving me: http://dev-kpl-pbi-vm:80/ReportServer

In SSRS I can use the global built-in variable followed by the folder structure to link to a report, but in PBIRS it is not opening the linked report. It shows me the following instead:

 

Unbenannt.png

 

Best,

Mogry

1 ACCEPTED SOLUTION


@Mogry wrote:

Neither http://dev-kpl-pbi-vm:80/ReportServer/report/test_report nor http://dev-kpl-pbi-vm:80/ReportServer/test_report is opening the report.


That is probably because neither of those match the format I suggested. As in my previous post, you need to have the report server url, then a question mark (?) then the path to the report.

 

So I would expect one of the following to work (I'm not sure if you need the leading / when the report is in the home folder)

 

http://dev-kpl-pbi-vm:80/ReportServer?/test_report

http://dev-kpl-pbi-vm:80/ReportServer?test_report 

View solution in original post

4 REPLIES 4
d_gosbell
Super User
Super User

What is the expression you were using in SSRS. As far as I am aware the url syntax for the ReportServer endpoint has not changed since SSRS 2005.

 

Typically you would use something like the following:

 

[&ReportServerUrl]?<path to report>

 

So you your case something like the following should work:

 

[&ReportServerUrl]?/test_report

 

I think it is the extra /report/ in your url that is used in the portal, but is not required by the ReportServer that is give you the issue.

Thanks for the reply. For me it looks like the built-in collection is not giving back the correct Report Server URL.

 

I need: dev-kpl-pbi-vm/Reports/report/

[&ReportServerUrl] is giving me: http://dev-kpl-pbi-vm:80/ReportServer

 

The expression is Globals!ReportServerUrl. This is the same which is used on the SSRS.

 

Neither http://dev-kpl-pbi-vm:80/ReportServer/report/test_report nor http://dev-kpl-pbi-vm:80/ReportServer/test_report is opening the report.


@Mogry wrote:

Neither http://dev-kpl-pbi-vm:80/ReportServer/report/test_report nor http://dev-kpl-pbi-vm:80/ReportServer/test_report is opening the report.


That is probably because neither of those match the format I suggested. As in my previous post, you need to have the report server url, then a question mark (?) then the path to the report.

 

So I would expect one of the following to work (I'm not sure if you need the leading / when the report is in the home folder)

 

http://dev-kpl-pbi-vm:80/ReportServer?/test_report

http://dev-kpl-pbi-vm:80/ReportServer?test_report 

View solution in original post

I totally missed the question mark. The report is opening with "http://dev-kpl-pbi-vm:80/ReportServer?/test_report" and the leading slash is necessary. 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!