Forum Discussion
Link from SSRS to Power BI report Server
Hi
I'm attempting to link through from an SSRS report to a power BI on premise Dashbord, using a parameter from SSRS report and feed through to the Power BI solution; opening the power BI dashboard in a separate Window.
I believe the way in which to do this uses javascript, but appear to be having some issues once also applying the filters.
This link works and renders in a new window, without the filter applied
="javascript:void(window.open('http://bireporting/reports/powerbi/COG/Matter/SelfService_Matter','_blank'))"
This link opens up the PBI with the filter applied, but no new window
="http://bireporting/reports/powerbi/COG/Matter/SelfService_Matter?filter=Matter%2FMatterID%20eq%20%27XXXXX.00035%27&rs:embed=true" But as a combined link for some reason it doesn;t work (click on it - and it does nothing)
="javascript:void(window.open('http://bireporting/reports/powerbi/COG/Matter/SelfService_Matter?filter=Matter%2FMatterID%20eq%20%27XXXXX.00035%27&rs:embed=true" & "','_blank'))"
Any ideas? Tried all sorts - and cant seem to get it to work with the filter applied.
Thanks
Neil
1 Reply
- Jon-Heide
Microsoft Employee
You can craft any type of URL from the SSRS paginated report, including URLs with filters to a PBI desktop report. However, running of javascript within that action is not allowed, as it could be used for malicous attacks, cross-site scripting, etc.