cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NEJO
Frequent Visitor

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
Microsoft

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
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.