Row level security - Report showing blanks on PBI service after data refresh

[D_soko]

I have a report that is supposed to be shared with different suppliers, but each supplier needs to see their own data and not other suppliers' data.

I have set up RLS in the following way: Say we have a supplier called Xx
1.  This role should only be able to access data for the current month

2. This role should only be able to access a specific Level of the report (i.e some pages should not be visible if the supplier has not subscribed to them). This has been done as below, to check the user logged in based on a Page Access table that I have created separately that shows the supplier email and attached to the page/level they have access to.

3. Finally, I have also filtered the Suppliers table that contains all information for each suppliers. The idea is that I have named all roles after the name of each supplier. The set up will be similar, and I will only change the supplier name respectively for each supplier onboarded.

On Power BI service, I have set up RLS by adding the supplier emails to the workspace as "viewer" as well as updating the security part on the dataset, by adding the specific supplier's email to the role (Xx@sample.com).

Having set up everything as guided by the PBI resources, I don't know why the data suddenly disappears from the report especially after refreshing the data. Any help on this will be highly appreciated

[GilbertQ]

Hi @D_soko 

This can be done with dynamic Row Level Security, please see the blog post below.

Dynamic Row Level Security with Power BI Made Simple - RADACAD

[GilbertQ]

Hi @D_soko 

As far as I understand your setup all the requirements need to be in a single role. Once you have it across multiple roles it is causing the RLS to return the blank data.

[D_soko]

Having one role cannot be in the solution for this particular implementation.

I'm using different roles because the data filtered needs to be different for each role i.e, depending on the supplier logging in.

For example - the same way we can create RLS for different people who should access data for different regions. Say, Germany would be a role on it's own, USA etc.. so that data filtered belongs to those particular countires.