RLS with Embedded reports

[Anonymous]

Hello everyone,

I am stucking in a situation. I published the PowerBI app and used Azure to embbed the reports on my company's website.

There is different data for different usernames logged in to their accounts on my company's website (they can come from externality also). However, we cannot set the RLS because our usernames (non-powerBI user) are not supported.

I also tried this post https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security. But it is not appropriate.

Is there anyway to solve this?

Thank you very much.

[v-jiascu-msft]

Hi @Anonymous,

The link just has the guide of deploying RLS in your scenario. Your scenario is the App-owns-data. Which part is not appropriate? Perhaps something conflicts with the considerations-and-limitations.

Best Regards,

Dale

[Anonymous]

What are your users login in with? Microsoft login? Your company's own login service? Azure AD? etc? 

[Anonymous]

Hi,

They login with my company's own service

[Anonymous]

How are your usernames not supported? Once you login to the website, you should keep some kind of information of who is logged in, like a username or email address. How do you know who is logged in at the time?