Forum Discussion
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:
Best,
Mogry
Anonymous 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)
4 Replies
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.
Anonymous 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)