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.
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!
Does RLS works for the option "Hide all rows"?