Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am trying to create a Static RLS where few should have access where column Phone has "Apple" and other should have access of all data no filter of column Phone
Hi,
create two RLS one with filter and another without any restricttion;
RLS_AppleOnly : TableName[Phone] = "Apple"
RLS_ALL : nothing,
and then you asign one role to some group of customers and the add the rest to the RLS_ALL
if this helps please mark it as a solution 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |