401 error

[lakshmi9228]

displaying 401 error while using RLS in power BI and struggling from yesterday by different ways.

[lakshmi9228]

How do we do that?

I dint get the point "column adjacent to the first visual and have row level on that second visual. " 

[nirvana_moksh]

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.

[nirvana_moksh]

Visual 1 will NOT have the column you want restriction onDefine RLS on the secondary table that contains the restricted columnDummy Data for secondary table containing the supposed restricted columnRelationship between both

[lakshmi9228]

I am doing as direct query by using a view from SQL, how can I do this visuals at that time?

[nirvana_moksh · Accepted solution]

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.

[lakshmi9228]

OrderID	OrderDetailId	CustomerID	CustomerEmail	OrderStatus
33512	6017	163712	[email protected]	Completed
33513	60172	233638	[email protected]	Completed
33520	6030	90063	[email protected]	Completed
33532	60301	233660	[email protected]	Completed
33532	60302	233660	[email protected]	Completed
33568	6018	233685	[email protected]	Completed

I am sorry, I can do this.
Please let me know if I can restrict the email address column