Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
Need Help regarding RLS for MUltiple Tables .
Here is the question Mentioned in the Link .
IF you click on the link you can find the screenshot and Excel what i am asking for ..
RLS for Multiple Tables
Click Here for RLS FIles
I have 4 Tables in that i have Table1, Region , District and Dealer Tables . Here i have Mentioned RLS for the all the Tables in the screenshot . PLease open the link and You can see what exactly i am asking for . I Need RLS for Multiple Tables USers / mail id.
Thanks in Advance
Sandeep
Solved! Go to Solution.
Hi, @avulasandeep
According to your description, I can roughly understand your requirement, I think you can try my steps:
[Dealer ID] in
SELECTCOLUMNS(
FILTER(
'Dealer',
[Email] = UserPrincipalName()),
"Dealer ID",[Dealer ID])
||
[District] in
SELECTCOLUMNS(
FILTER(
'District',
[Email] = UserPrincipalName()),
"District",[District])
||
[Region] in
SELECTCOLUMNS(
FILTER(
'Region',
[Email] = UserPrincipalName()),
"Region",[Region])
USERPRINCIPALNAME = USERPRINCIPALNAME()
And you can get what you want.
You can download my test pbix file below
The document link I followed:
https://radacad.com/dynamic-row-level-security-in-power-bi-with-exclude-and-include-rules
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @avulasandeep
According to your description, I can roughly understand your requirement, I think you can try my steps:
[Dealer ID] in
SELECTCOLUMNS(
FILTER(
'Dealer',
[Email] = UserPrincipalName()),
"Dealer ID",[Dealer ID])
||
[District] in
SELECTCOLUMNS(
FILTER(
'District',
[Email] = UserPrincipalName()),
"District",[District])
||
[Region] in
SELECTCOLUMNS(
FILTER(
'Region',
[Email] = UserPrincipalName()),
"Region",[Region])
USERPRINCIPALNAME = USERPRINCIPALNAME()
And you can get what you want.
You can download my test pbix file below
The document link I followed:
https://radacad.com/dynamic-row-level-security-in-power-bi-with-exclude-and-include-rules
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.