March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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
PBI
Solved! Go to Solution.
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.
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
For Interactive (.pbix) reports, you can see as below on PBIRS
Hope this helps!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
4 | |
4 | |
4 | |
3 | |
3 |