Forum Discussion
401 error
The screenshots titled as visuals is basically the 'Table' visuals that you see in the 'Visualizations' pane on the right on the PBI Desktop, so you can create these visuals irrespective of using Direct Query or Not. The secondary RLS table I was referring to is a manual table that you will create and maintain and will be the source of the second visual which will basically be the Column you want the restriction set on.
Did you assign the users that role on the PBI Service as well?
Yes, They are members for the workspace
Hey Lakshmi, adding users to workspace only gives them access to reports and dashaboards which dont have RLS set on them. If any reports have RLS then you need to go to its respective dataset, click on the ellipsis and click on security. Whichever role you defined on the Power BI Desktop level will show up and then you have to add users to those roles individually.
I have done that.
I restricted to few people by entering their email address.
I dint restrict to few people.
Now the people who are not restricted are getting error.Can you paste the screenshot for the 401 error?
The below screenshot shows the screen wherein you will assign the roles to the users, the roles I defined were named Account Manager, Team Lead and Global View which were at the PBI Desktop level: