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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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