Forum Discussion

SuperFiets_'s avatar
SuperFiets_
Icon for Helper I rankHelper I
2 years ago

Filtering a semantic model for end-consumer

Hi everyone,   We're implementing an end-to-end solution using Microsoft Fabric, including Dataflows Gen2, Pipelines, Lakehouses, and Warehouses. However, we’re facing a challenge and need your adv...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Read about the difference between static RLS and dynamic RLS.  In your case a reference table in combination with USERPRINCIPALNAME may be more efficient.

SuperFiets_'s avatar
SuperFiets_
Icon for Helper I rankHelper I
2 years ago

I checked the option for Dynamic RLS, but I am afraid it won't work for the scenario.

 

Say I have a O365 group per client, we have about 20 users. But the same user can be a part of multiple O365 groups. In the end this means that that user can still see all the clients he is connected to, instead of just one client per template we publish..