Embedded RLS - Apps owns data - Dynamic usernames

PowerKoen — Wed, 08 May 2019 08:11:34 GMT

Hi there,

Read several posts/blogs but still got a question. We have a portal which embedded power bi (non power bi users / apps owns data).

1. At the generatetokenrequest, we can lookup the 'EffectiveIdentity'. Is it possible to lookup a SQL table? Based on the e-mail login for the portal? So if a client logs into the portal with its e-mail/username it will lookup this e-mail/username in the SQL table and pass the customer code (from the SQL table) as username for power BI?

2. Is it possible to pass multiple usernames? So client A, is linked to customer code 112 & 113. Pass this as usernames to power bi. In the power bi report RLS filters the customer code tabel on 112 & 113. Or do I need to make a table inside PowerBI which links username 112, to multiple other codes (113/114 etc)?

Thank you in advance!

topic Embedded RLS - Apps owns data - Dynamic usernames in Developer

Embedded RLS - Apps owns data - Dynamic usernames