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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |