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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Adding a Role to Power BI Report Server

I need to create a role that will give our orginizational leaders browser access to all folders, dashboards, and reports.

 

The documentation provided by MS is actually for SSRS 2017, which is not Power BI Report Server even if it was built off of it from a backend perspective.

https://docs.microsoft.com/en-us/sql/reporting-services/security/role-definitions-create-delete-or-m...

 

  1. In Object Explorer, expand a report server node.

  2. Expand the Security folder.

  3. If you're creating an item-level role definition, right-click Roles > New Role.

    Or, if you're creating a system-level role definition, right-click System Roles > New System Role.

If I open up the Security folder under the instance I have Server Roles.  Under the ReportServer database I have Database Roles, and Application Roles - this last one is empty.

 

Is someone able to provide some steps to properly add a browser role that will grant a specific AD group access to everything?

To follow up: Is there a way for this role to NOT BE REMOVED by content managers?

1 ACCEPTED SOLUTION
saglamtimur
Resolver II
Resolver II

Hi,

The documentatition is not clear where to connect, so confusing. From SSMS, you must connect to "Reporting Services" server type, not "Database Engine"

4.PNG

View solution in original post

2 REPLIES 2
saglamtimur
Resolver II
Resolver II

Hi,

The documentatition is not clear where to connect, so confusing. From SSMS, you must connect to "Reporting Services" server type, not "Database Engine"

4.PNG

Anonymous
Not applicable

@saglamtimur - ahh...that makes total sense.  I 100% even forgot about being able to connect to SSRS that way.  Thank you sir.

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!

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.