Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
98 | |
39 | |
30 |