Hi,
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?
