Dynamic Security in RLS - Collection of Filters passeed as Username

[Anonymous]

Hi

My issue is with Dynamic Security RLS I am following the article here - https://learn.microsoft.com/en-us/power-bi/developer/embedded/cloud-rls

I need to filter the username, ultimately, as a collection of groups but primarily as onegroup and I need to return rows that our geographic_description “startswith” so if a passed username is ABC rows with a “geographic_description” of “abc” and “abcfg” and “abchgs” would all be returned.

This is achieved with  the following code

• LEFT (CustomerVehicle[geographic_description], LEN ( username() ) ) = username()

What I am trying to achieve is sending through multiple “Business Groups” as filters for the “geographic_descriptions” in the username as a csv string – e.g username() = “abc,xyz,def” as all to be used in a Startswith scenario.

My issue is with creating a collection of filters from the csv of Business Groups and returning the row if the “Geographic_Description starts with ANY of the passed filters “Business Groups”

[v-zhangti]

Hi, @Anonymous 

Please refer to the following links in the hopes of helping you.
Solved: Dynamic RLS with security group - Microsoft Power BI Community

Solved: Security: RLS & filters - Microsoft Power BI Community

Solved: Dynamic RLS filtering multiple tables - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

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