Defining row level security dynamically

[JonGunnar]

Hi, in a customer database some customer with a certain product should receive a report monthly containing their own data only.

This process can be managed with

1. RLS in Desktop

2. Security on row level in powerbi.com

3. Sending e-mail with PDF attachment using Power Automate

So far so good, however the number of potential customers are more than I would like to do manually with one role per customer and same in powerbi.com and one automated e-mail per customer.

Is there some method to do this dynamically and automatically?

JG

[lbendlin]

What you are describing is not dynamic RLS, it is static RLS.  Dynamic RLS is based on USERPRINCIPALNAME  which may or may not be applicable/available in your scenario.

Use a RLS mapping table that holds the customers and their permissions, and then have one role with rules based on the permissions sets.