RLS - strange behavior

[btodres]

It seems that if I setup RLS for ANY user who I give access to a dashboard, then I need to also setup RLS for ALL other users, even if I don't secure anything for those otehr users, otherwise the dashboards that I share with a user who I havent setup RLS for can no longer see any visuals within a dashborad report.  Anyone else experiencing this issue?

[Greg_Deckler]

One other note on this, I did notice that when I did the RLS thing with a user, while I did not test a different user other than myself, I was able to see everything and was not setup in a specific role of any kind, so it must not extend to the owner of the data set.

[Greg_Deckler]

Well, it is still Preview technically. And, no "wildcard". To a certain degree this makes sense. You might want to create a custom column in your dataset that is essentially:

RLS = 1

Then you could setup your RLS for all of your other users to just be:

Table[RLS] = 1

Essentially, create your own global wildcard for "everything"

[btodres]

thx, for your reply.  I found that all I have to do is add the user name of anyone i shared a dashboard with in a new RLS Role and not include any rules for those users and they can then see and interact with any dashboards I shared with them.  The other users who I do want to have various RLS rules enabled are not impacted.

[Greg_Deckler]

Very cool, thanks for the update. One other thing that I have found, and they warn you about it when you setup RLS, is that if you are using a Desktop file and republish, it blows away your RLS. Assuming this will be fixed before it gets out of preview.

[Anonymous]

ewww... That is really good to know.

Thanks @Greg_Deckler