Forum Discussion
RLS from 2 Different Table ending up to 2 Different Columns
Hello all,
I have 3 tables in Power Bi one is Sale Traders, Purchase Trader and Shipmens. Sometimes as you can see a Purchase Trader Could be also Sale Trader. In my Shipment table i have all the Informations and of course the Sale trader and Purchase Trader (in same line) which are connected with the 2 tables through the corresponding field. I have 2 pages for the Sales and Purchase Budget and i would like to implement row level security. Raphael E in some contracts is Sale Trader in some other is Purchase Trader.
I would like Raphael access the Report i would like him to see in Sales Budget Page only his Data as Sale Trader and in Purchase Budget Page only his data as Purchase Trader.
But i am implementing the RLS by puting the filters in in 2 tables but Raphael E see the his Data as Purchase Trader in Purchase Budget page and data of other Traders in Sales Budget page because he was the purchase Trader on those sales.
Do you know an efficient way to implement this without diplicating my table ?
| Sale Trader |
| George A |
| Michael S |
| Raphael E |
| Purchase Sub Trader |
| Mathew M |
| Michael S |
| Raphael E |
1 Reply
- AnonymousNot applicable
Hi pbi1908
Can you provide the screenshot of the table structure that contains your three tables? So that I can help you better. Please remove any sensitive data in advance.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.