RLS Issue with shared dataset

[MrNico28]

Hi everyone,

I'm having an issue due to implemmenting the RLS in one of my datasets.

I have the "A" Dataset, published in the "1A" workspace.

The access for this "1A" workspace is exclusive for me the admin and the directors board. Here we have all the datasets that we have in our PBI enviroment.

From this workspace, we share the datasets to different workspaces. We have a workspace for every department in our company (Sales, accounting, marketing, logistics, etc.)

When I start the RLS in the "A" Dataset, 3 roles where created, and I assigned an email with pro license for every role. But, after publishing this dataset to the "1A" workspace, the other workspaces cannot see any data from any dashboard connnected to that shared dataset.

Me as the owner of the dataset and PBI admin, don't have any trouble looking the data, and if I enter to the other workspaces, I can see all the data in the dashboards created from the shared dataset without any problem.

I was looking for a solution here in the forum, and one was to share the access to the workspace "1A" to the user, bur I can't do that due to all the datasets with confidential information are in this workspace, with viewer access they can see al the dashboards and datasets of this workspace, but they still can't see the information in their reports. But if I gave them member access, then they can see the data as normal.

Please, help me to understand if I have to add an RLS role to the remaining users that shoudln't have any restriction to the data. Or any other solution will be very welcomed.

Thanks for your attention

Looking forward for your help

[_sfrost]

@MrNico28 

Provide them read permission to the dataset by navigating to manage permissions of the dataset in 1A workspace and the error message you attached must not appear but they might not see data due to RLS. Then assign them the appropriate RLS role. They should then be able to access and see the data.

Did I answer your question? Please accept this as the solution!

[MrNico28]

@_sfrost @blopez11 

This is the screenshot of my RLS site in the PBI Service

[blopez11]

In additon to adding users to the RLS roles, you need to grant them read-only privileges on the shared dataset

In the workspace with the shared dataset, when you select the "More options" icon (three vertical dots) when hovering over the dataset, then select "Manage permissions", what do you see?

[MrNico28]

Hi @blopez11  and @_sfrost 

The privileges were alredy given. I have shared the dataset but the main issue is with the users that doesn't have RLS applied.

The v.bebe and v.bienestar are the users that have to had RLS.

But this issue is with the ussers that doesn't apply RLS

The users with the RLS assigned don't have any problem, they can see the data without inconvenience

In this case is compras@pepeganga.com who has the issue

[blopez11 · Accepted solution]

Oh, I see, that wasn't clear in the original post.  If you use RLS, then everyone, outside of those that have access to the workspace must be assigned to an RLS role.  If you want some folks to have full access, then create an RLS role where the DAX just returns true, then assign folks that need full report access to that role

[MrNico28]

Thank you so much @blopez11 @_sfrost  for your help. Now it totally works.

Sorry for the unclear explanation, I tried to do my best.

In any video or material that I found was the condition to add a "general" level to the remaining users.

So, that means that every time I create a user I have to assign them to the general level?

Thanks again, I really appreciate it