Row Level Security

[RanjanThammaiah]

Hi All,

I Wanted to create Row-level security based on the Country list I have. But the question is here I have a list of 68 countries.

Not sure if there is any dynamic way to create RLS.

If I have to create for each country then will end up having many.

Regards,

[Anonymous]

Hi @RanjanThammaiah ,

Here's a similar post you can refer to

Solved: Dynamic Row Level Security-to show all country for... - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@RanjanThammaiah , Create a table with country and email id of the person having access to it and then create a role using userprinicpalname

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk