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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
AhmedMorsy
Regular Visitor

Managing access to multiple reports for multiple projects in one workspace

I have multiple project's reports to be published in one workspace, each project has certain users to access their reports. knowing that I have to give a consumer access to all project’s users to the workspace in order to allow them see the reports. I want to avoid they access the other project's reports not related to them.

Please share with me your thoughts on a way to control the access to only relevant reports.

5 REPLIES 5
v-yalanwu-msft
Community Support
Community Support

Hi, @AhmedMorsy ;

Page-level security and Visual-level security is not yet supported in Power BI.  we need workarounds to implement it.

https://radacad.com/page-level-security-workaround-in-power-bi

 

Page level security with RLS 

 

https://www.youtube.com/watch?v=an7n2kSTBk0


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Understand though that all workarounds are insecure. Nothing will prevent the user from seeing a page they are not supposed to see if they have access to the report and get the URL of the page if it is shared via email, teams or however, whether inadvertently or intentionally. 

Have any of these helped @AhmedMorsy ? If so, could you mark them by accepting as a solution. Note that there may not be the actualy solution you want due to product limitations at this time, so "there isn't a good solution for your particular scenario" is a good answer, just not the one you want.😁



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
AhmedMorsy
Regular Visitor

To merge 13 reports in one report is a quite challenging here and will make it very heavy to update the data. can I use the RLS only to give access to specific project report's?

No. RLS is at the record level - "ROW Level Security"

If you already have 13 reports, put them in different workspaces, and add users to the apps for those workspaces. The new workspace experience in Power BI - Power BI | Microsoft Docs



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
edhans
Super User
Super User

The best way is Row Level Security - RLS. As each user logs in, the report filters itself to only show what the Power BI dev allows for that user/user group. You have to write one report.

You can publish a "golden dataset" in one workspace, then create Live Connected reports to it in other workspaces that you restrict permissions to by user/user group. Downside is if you need to make a change to the report, you have to make the same change to all copies (adding a new visual for example)

 

You cannot restrict reports in a single workspace to a set of users. Everyone with access to the workspace/app can see all reports in the workspace/app.

 

You may google on ways to hide pages based on user. Do not rely on these tricks. They are clever, but not secure. Though a user may not be able to navigate to a page within the report, if Report User A has visibilty to page 2, and copies that URL to an email or chat and asks Report User B about it, even though User B shouldn't see it, that URL will work for them because they have access to the report.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.