IAuthentication and Authorization Process In Power BI Report Server

[Sayani92]

My project is currently in requirement gathering and research phase . We are planning for on premise Power BI solution as client requires that.

Need details on authentication and authorization process of a user to POWER BI dashboards in POWER BI REPORT SERVER.

[aduguid · Accepted solution]

I setup active directory security groups to manage user access to the folders. I then use a database user account (service account) for the data sources. Then if you need to you can setup row level security within each dashboard. 

[v-jtian-msft · Accepted solution]

Hi,@aduguid,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hi,@Sayani92 I am glad to help you.
 @aduguid has made good suggestions.
Use Active Directory security groups to manage user access to folders: this method simplifies user management. By adding users to a specific AD security group, you can easily control their access to different folders in Power BI Report Server. Setting up RLS on a dataset allows you to set up their access to the data according to different user identities, ensuring that users can only see the data that they have the right to access, which further enhances the security and privacy of the data.
Below is the documentation I found and the issue I have resolved, I hope it will help you.

URL:
Configure Basic authentication on the report server - SQL Server Reporting Services (SSRS) | Microso...
Set up row-level security in Power BI paginated reports - Power BI | Microsoft Learn
Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn
Solved: PBI Report - Windows Authentication "As User Viewi... - Microsoft Fabric Community
Solved: Upload a Report on a Power BI Report Server with A... - Microsoft Fabric Community

By implementing RLS, you can protect report data by assigning roles to different report access users, ensuring that the results each user sees are restricted by role permissions.
User authentication and authorization process is a key part of ensuring data security and access control, configure these settings to effectively protect your report data.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aduguid · Accepted solution]

I setup active directory security groups to manage user access to the folders. I then use a database user account (service account) for the data sources. Then if you need to you can setup row level security within each dashboard.