cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lukmtb08
Helper II
Helper II

Dynamic RLS does not work in Service

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! 

🙂

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

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.

vtangjiemsft_0-1669880782358.png
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. 

View solution in original post

5 REPLIES 5
v-tangjie-msft
Community Support
Community Support

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.

vtangjiemsft_0-1669880782358.png
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
Super User
Super User

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes, I have added them. 

Yes, they are viewer. 

 

Can viewers refresh s dataflow? 

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. 

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

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors