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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lucaspmccarthy
New Member

On-prem Report Server - Ability to 'Create linked report' Like in SSRS

Hi All,

 

For security reasons, my firm is using the report server on-prem, and I noticed that there does not seem to be the ability to 'Create a linked report' in the report server like SSRS had. Please see screenshots below. 

 

Our plan was to keep reports in a centralized location, and link reports to other directories as needed. For example, someone in an HR department and Finance department may need access to the same report, so a link is placed in both the HR and Finance folder that points back to the report that was created and stored in a directory called Reports. Any idea on if this kind of thing is feasible in the report server?  Also happy to hear alternatives to approaching this. Security and maintence of reports are most important to consider.

 

Thank you,

 

SSRS

lucaspmccarthy_0-1649336980404.png

 

PBI

lucaspmccarthy_1-1649338220190.png

 

 

 

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User

So the linked reports feature still works in Power BI Report Server, but it only works with paginated reports.

 

What we are doing with Report Server and PowerBI Reports is to put our core tabular models on a SQL Server Analysis Services instance. So all the data and measures are stored and secured centrally and then we have multiple "thin" reports in live connect mode back against these data models. It's not ideal if you want the identical report in both Finance and HR, but it does mean your measures and data loads and security roles can be centralized.

View solution in original post

2 REPLIES 2
d_gosbell
Super User
Super User

So the linked reports feature still works in Power BI Report Server, but it only works with paginated reports.

 

What we are doing with Report Server and PowerBI Reports is to put our core tabular models on a SQL Server Analysis Services instance. So all the data and measures are stored and secured centrally and then we have multiple "thin" reports in live connect mode back against these data models. It's not ideal if you want the identical report in both Finance and HR, but it does mean your measures and data loads and security roles can be centralized.

In additon to @d_gosbell reply, 

 

For paginated report (.rdl) AKA SSRS report, you can see as below on PBIRS

sevenhills_0-1649439904498.png

 

For Interactive (.pbix) reports, you can see as below on PBIRS

sevenhills_1-1649440043965.png

Hope this helps!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors