Power BI Embedded - Leverage Application Security in Reports

I would accomplish this using Dynamic security approach which has been used with analysis services for many years.

The approach is straightforward.  You must create a security dimension with user names as well tied to entities you want to secure.   DAX leveraging  CustomData can allow you to set the user identity and then return just the data for the user based on their security grants (the data refreshes would update any new entity security you may have set to keep model up to date).

Please look at the post below that suggest how it can be done.    This relates to SSAS,  but you can also do this thru a Power BI model (which internally is using SSAS Tabular for model).

https://www.kasperonbi.com/dynamic-security-made-easy-with-ssas-2016-and-power-bi/

Good luck!

Luis

If you find this answers your question,  you may wish to mark as solved to allow other users to quickly find answer.