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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
NEJO
Advocate I
Advocate I

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 1
Jon-Heide
Microsoft Employee
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. 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.