Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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)
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)
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.
User | Count |
---|---|
10 | |
10 | |
3 | |
2 | |
1 |