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.
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?
This is the error they are getting
What I can suggest is to first impersonate the role (Test as Role) of the people seeing this error and see if you are getting the same. If you are then revist your model and see if any of the relationship's has changed from single to both or are there are any breaks there and Test as Role for the users experiencing this on PBI Desktop too. That usually is where I have found my errors to be at and it has always resulted in success!