Forum Discussion

NEJO's avatar
NEJO
Icon for Advocate I rankAdvocate I
5 years ago

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's avatar
    Jon-Heide
    Icon for Microsoft Employee rankMicrosoft 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.