Can I restrict some users to see only a subset of all reports (PowerBI Pro)

[centroid]

I have created a database through power query and visuals in the PowerBi desktop app. Then I publish my powerbi file through PowerBI through the desktop app to the cloud service. I would like to share the visuals with different users in our organization. Not everyone should be allowed to see all the reports. Some specific reports should be spread only to certain employees. The visuals are tailored for different staff members working in different departments. Is this possible? Or do I have to create different files in Power BI desktop and then publish them individually? We have a PowerBI Pro license. 

[v-janeyg-msft · Accepted solution]

Hi, @centroid 

Yes, You can do it by using RLS functions. It can be used to restrict data access for given users. You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions. Then In the Power BI service, you can add a member to the role by typing in the email address or name of the user or security group.

You can first follw the steps to learn how to use:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

How to Setup Row Level Security (RLS) in Microsoft Power BI (key2consulting.com)
And for your needs, I think you need to do some adjustment in your reports, For example: Hide the pages first, only qualified users can switch to the corresponding page through buttons or other methods.

Here are some examples:

Did you know you can now selectively show report pages for specific users in Power BI? - Reporting/A...

How to Navigate Pages Dynamically with RLS? - YouTube

If you have problems, please feel free to ask me.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Community Support Team _ Janey

[SivaMani]

@centroid, Go for separate files and share them with relevant users, As Power BI doesn't support show/hide report pages/visuals based on users.