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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.