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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

On Prem Report Server SSAS Row Level Security different domains


We have a Power BI On Prem report server set up with connections to SQL Server SSAS Cubes and database. The row level security is configured at the SSAS cube level. The design is very typical with a security table that defines user ids and their access and is currently enforced by capturing the windows user login and mapping it to a security table user ids. The report servers and databases are in domain 1. If users in domain 1 login and create Power BI reports in Desktop and run them, the security is triggered and applied as expected.


We have some users in domain 2 who we wish to provide access to the reports on the report server in domain 1 from an app.  The users from domain 2 will run the reports against the same SSAS cubes in domain 1. All the users in domian 2 don't have user accounts in Domain 1. When users in domain 2 access the reports, they still need to have row level security applied using the security model set up in domain 1. Are there options to use the current security model and trigger row level security when users in domain 2 access these reports. The security table also has the list of domain 2 users with the access defined. Can we pass the user id accessing the report from domain 2 and trigger row level security?


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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