Row-level security not working inside Apps

[caioproiete]

If I configure row-level security rules in a report and publish it to Power BI Service, it works fine when I open the report inside a workspace.

But if I publish an app of the workspace, then any report that uses row-level security fails to open to all users, with the message "Couldn't load the data for this visual"

Error message when opening reports with RLS, via an App in Power BIError message when opening reports with RLS, via an App in Power BI

[v-qiuyu-msft]

Hi @caioproiete,

Are those end users members of that app workspace? Members of this app workspace have view only permission or edit permission?

Please check if your scenario meet below conditions:

1. App workspace members have view only permission and those end users are members in that app workspace.

2. Those end users are not members of that app workspace.

If you meet one of above condition, you need to add those end users as members of the RLS role. Please go to dataset security, add that user as a member of the RLS role, then update the published app.

Best Regards,
Qiuyun Yu

[caioproiete]

Thanks @Vicky_Song. The issue was caused Power BI requires that users belong to one of the roles created in the dataset. I had to create a role called "Everyone" and add all users that have access to the workspace.

This is far from ideal, and I'm looking forward to having this resolved by implementing this idea for adding a default role for row level security.