rls
4 TopicsRow Level Security Issue
Hi everyone, I'm facing a problem applying a Row Level Security to my report. I have create a Rol where I filter the Countries depend on the user email. And when I click on test a role it works. Then when I publish the report on the workspace I can see the Role created. But the issue comes when anyone opens it and It is not filtered by the country of the person who is watching it. It is as if the role had not been applied. Do you know if i have to change anything on my workspace/report/database settings? Thank you, Regards.Solved873Views0likes1CommentProblem with PowerBI (RLS) with Direct Query
Hello PBI Community, I have a question regarding using RLS in combination with DirectQuery connections. I have the following situation in my data model: With this relation, I’m able to filter the “Sales Markets Ih” table in the report. Now I create a new role (RLS) with the DAX query: [DEPARTMENT] = USERPRINCIPALNAME() and upload the report, but the report will not be filtered by the users via the RLS query: Can you help me with this? Kind regards Nico2.1KViews0likes7CommentsRLS Issue with shared dataset
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 help821Views0likes1Comment