Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Link from SSRS to Power BI report Server


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






This link opens up the PBI with the filter applied, but no new window


But as a combined link for some reason it doesn;t work (click on it - and it does nothing)



="javascript:void('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. 






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

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.