Forum Discussion
401 error
- 8 years ago
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.
How do we do that?
I dint get the point "column adjacent to the first visual and have row level on that second visual. "
This is what I came up with, you will have to change things obviosuly based on your requirement and also this is just a starting point and the only way I thought you can achieve this, you will have to break the column that needs the restriction upon and apply RLS on that column and make sure no relationship is defined between these two tables else the RLS will trickle to the other table as well.
Not a perfect solution but I think this should be a good starting point.