Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Power BI Pro license users encountered error "You can't see the content of this report because you don't have permissions to the underlying dataset. The underlying dataset uses row-level security (RLS)." when accessing the dataset with permission Read, Reshare, Rebuild granted to them and this dataset has RLS configured. Could anyone advise where went wrong that causes them not be able to use the dataset. The dataset has been published to a workspace with premium capacity.
Solved! Go to Solution.
Yes that's the only solution I'm aware of. I generally have an empty role called "No RLS" but users have to be specifically assigned to it. We make use of Azure Security Groups to make it managable.
Hi @laikittmun ,
If you have set RLS in a report, any user haven't been set a role in the RLS can't see the report, unless he is at least a contributor of the workspace.
According to your description, I have two solutions.
1. You can add a new role in Power BI Desktop and set nothing in the "Table filter DAX expression" box, like below.
Then if you have access to admin center, you can create a distribution or security group with the 80 users and give them the Full access role in dataset security setting. Otherwise, you need to add them one by one.
2.Give the 80 users contributor role of the workspace, in this way, they can see whole content of the report and other reports in the workspace.
Reference:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Roles in the new workspaces in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @laikittmun ,
If you have set RLS in a report, any user haven't been set a role in the RLS can't see the report, unless he is at least a contributor of the workspace.
According to your description, I have two solutions.
1. You can add a new role in Power BI Desktop and set nothing in the "Table filter DAX expression" box, like below.
Then if you have access to admin center, you can create a distribution or security group with the 80 users and give them the Full access role in dataset security setting. Otherwise, you need to add them one by one.
2.Give the 80 users contributor role of the workspace, in this way, they can see whole content of the report and other reports in the workspace.
Reference:Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Roles in the new workspaces in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Just to check, is the workspace definently premium capacity and not premium per user?
Assuming that's not the problem, if you click the three dots next to the dataset in the workspace and click security it should show you the roles for RLS.
It sounds like power bi doesn't think the users in question are a member of any role.
Start by checking that and then we can investigate further.
The workspace is under premium capacity. Just discover that this error will return if the user is not assign to any of the Security Role created for the datasets. Let say i have 100 users to access the datasets, but only 20 of them will be restricted to see data that relavant to them only. So I have created security roles to assign these 20 users and they didnt hit this error. Can I conclude that I have to create a security role without any filtering in it and assign the rest of the 80 users who should not have data restriction to avoid this error ? Any other better way for these 80 users to avoid this error when accessing the dataset ?
Yes that's the only solution I'm aware of. I generally have an empty role called "No RLS" but users have to be specifically assigned to it. We make use of Azure Security Groups to make it managable.