The report cannot be displayed because the underlying dataset uses row-level security (RLS)

[LarsK22]

Hello Forum, 

I have the case that I have published several datasets and associated dashboards via the Power BI service. I then display these for my colleagues via a SharePoint overview.
Now I have the problem that some users get the following error message - and can not see the dashboards.

• The report cannot be displayed because the underlying dataset uses row-level security (RLS)

I have already managed the accesses to the respective workspace, dataset and report and added the respective people with the appropriate permissions. However, without success the error persists.

Subsequently, I pressed the 3 dots at the corresponding datasets and looked at the "Security" area. There are roles stored. However, only for certain persons. Other people who do not have roles can see the reports, but others who do not have roles can not see the reports.

There are two areas in the sharepoint. One for Sales, for which the permissions were created, and a general one for other departments.

Is this a bug or how can I solve the problem? Would be a possibility to remove the roles in general?

Thanks in advance and many greetings,

Lars

[Brunner_BI]

Everyone who should see some data needs to be as "viewer" in the workspace of the dataset.

Besides obviously adding them to RLS groups in the "security" tab.

[LarsK22]

What is the procedure when people should see everything from the dashboard?  E.g. the team leader should see everything. The respective field staff only their specific country area.

I had always handled this by not adding them in the "Manage Role" area. However, now you get the error listed above.

[Brunner_BI]

You can create a role that has no filter applied and then assign them that role.