Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Keerthanagowsi
Frequent Visitor

Dynamic Row Level Security with custom column values

Hi,

 

I have to apply dynamic RLS at country and city level in one of my dashboards. All the details are fed through a table. I have checked for applying dynamic RLS in web and found that through DAX expression, we can achieve it. But the thing is that the input of my access table will be in the following format.

 

EmailCity Country
emailid1ChennaiIndia
emailid2ALLALL
emailid3ALLALL

 

And in my source table i won't be having "ALL" in the City, Country fields. Can any of you help me in solving this?

 

Thanks much in advance.

2 REPLIES 2
parry2k
Super User
Super User

@Keerthanagowsi check these two videos on my channel and see if it helps:

 

How to set up conditional Row Level Security - RLS pattern in Power BI - YouTube

 

Learn basics of Row Level Security (RLS) - How ALL function is used for the solution? - YouTube



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Hi @parry2k 

Thanks for the videos. But my problem is different. If the city/country columns of my access input table is ALL, then the user should be able to access all the country and city data.

And my source table will not have a data called ALL in the city/country columns.

Is there a way to apply RLS, that if the access input table have an entry as ALL in city or country, then user should access all the data, else if the column have specific city/country that should be shown for the user?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.