Extend RLS to the composite model which already has RLS implemented

[alexa_0028]

Hi All,

I have a PowerBI model which already has the RLS working on it perfectly. I am doing data blending and creating composite model by adding the external data from sharepoint to the already published model and add more RLS on top of exisiting.

I have created a role Employee as with filtering on lvl1 and lvl2 tables like below.

When I check the role on desktop it works fine but when I publish on service it says cannot load visual data error.
I am not sure what I am missing here, can someone please assist?
1. Is it because I am doing lvl1 filtering as [manager email]= userprincipalname() and lvl2 as [email]= userprincipalname() 

Have someone faced similar issue?

[Anonymous]

Hi @alexa_0028 ,

Any detailed error message?

You may take a look at this document.

https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-azure-b2b-power-bi#dynamic-row-level-s... 

Best Regards,

Jay