RLS working in desktop but not powerbi online

[Anonymous]

Hi All, 

I have implemented row level security in powerbi desktop and it works perfectly fine when i test it in the "view as role" function but when I publish it to the app, it does not work anymore. 

What am i missing here? 

Thanks so much for your help! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

I think you forget to dispatch roles to users on power bi service side, right? AFAIK, RLS feature requires dispatch roles to users who have read permission on correspond datasets. (notice: RLS does not work on edit permission users)

You can refer to official document to know more about these:

Row-level security (RLS) with Power BI 

Regards,

Xiaoxin Sheng

[Anonymous]

i think we are almost at the solution here because i did not set roles in service. 

The main visuals i want my end users to see are the Reports and not dashboard. So my question is do i have to give access in both reports and also in the underlying datasets? 

[Anonymous]

Hi @Anonymous ,

RLS works on datasets, the reports and dashboards which created based on that dataset will also enable RLS filter effects.(notice: please double check your sharing setting to confirm not assign edit permissions to your users)

For share operations, they need access permissions to view your report contents. (except you publish to group workspace)

Regards,

Xiaoxni Sheng