Forum Discussion
SuperFiets_
2 years agoHelper I
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...
lbendlin
2 years agoSuper User
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_
2 years agoHelper I
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..