Dynamic RLS does not work in Service

[lukmtb08]

Hi, 

I have set up dynamic RLS in Power BI Desktop and it works perfect in PBI Desktop. The RLS table has a M:N relationship and filters in both direction. Also all persons are member of the workspace and are part of the role within the dataset.

When I publish it to Power BI Service, it works only for one users, which I have added after publishing the report with rls. For all other Users it is not working. At first they all were "Members", I changed all to Viewers, but it does still not work after 30 minutes.

Do you have any ideas?  

Thank you in advance! 

🙂

[v-tangjie-msft · Accepted solution]

Hi @lukmtb08 ,

The main reason RLS doesn't work is because the person viewing the report has edit access to the dataset. Double-check that your viewer is a member of the workspace or has edit permissions for the report.

If possible, you can upload the report to another new workspace for testing.

Please note if the relationship requires the cross-filter direction to be both directions (two-way cross-filtering), ensure that the Apply Security Filter Bidirectionally option is enabled for RLS to work properly.
In addition, you can refer to this document to check the restrictions on RLS.

You can refer to the following documents that may be helpful to you:

RLS issue - on Power BI service (when Test as a Role) | Power BI Exchange (pbiusergroup.com)

Dynamic RLS In Power BI | Microsoft Gold Partner | Addend Analytics

Best Regards,

Neeko Tang

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

[GilbertQ]

Hi @lukmtb08 

Have you added those users to the Roles in the Security section of your dataset?

And as you confirmed all the users are now "Viewers" of the app workspace?

[lukmtb08]

Yes, I have added them. 

Yes, they are viewer. 

Can viewers refresh s dataflow? 

[v-tangjie-msft]

Hi @lukmtb08 ,

The workspace role "Viewer" can refresh the dataflow.

You can refer to the following documents for more information about the refresh of the dataflow.

How to Use Dataflow to Make the Refresh of Power BI Solution FASTER! - RADACAD

Understanding and optimizing dataflows refresh - Power BI | Microsoft Learn

Power BI – Scheduled Refresh for your Dataflow - European SharePoint, Office 365 & Azure Conference,...

Best Regards,

Neeko Tang

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

[lukmtb08]

I tried it, Viewer can not refresh dataflows, as they are not able to see dataflows and datasets at all.