Forum Discussion
RLS affected by indirect relationship?
Hi everyone,
Would you mind giving me a hand on the relationship setting, please?
I have 3 tables and 2 of them ties with RLS using User name. I want to create a page showing number of visit by user (from Tbl_Time) and also the comment made by the user (from Tbl_comment). But I found that this doesn't work with RLS.
Issue: When View as User Larry, nothing is shown. Expect 1 row to be displayed in the top table and blank in the bottom table
Tbl_Comment
| ProjectCode | Comment | User (Used as RLS) |
| 2011 | AAA | Joseph |
Tbl_Time
| ProjectCode | Year | User (Used as RLS) |
| 2011 | 2023 | Larry |
| 2011 | 2022 | Joseph |
Tbl_Summary
| ProjectName | ProjectCode | Size |
| Apple | 2011 | 99 |
| Apple | 2099 | 50 |
| Pear | 3413 | 20 |
Relationship
Tbl_Summary (ProjectCode) - Tbl_Time (ProjectCode) [1:Many]
Tbl_Summary (ProjectCode) - Tbl_Comment (ProjectCode) [1:1]
Appreciate your advice and thanks in advance!
Cheers, J
1 Reply
- v-yueyunzh-msft
Community Support
Hi , CMHSC
According to your description, you want to set RLS in the two fact tables. And the [Tbl_Symmary] is the dimension table .
For your need , i think you can set the RLS just in the two fact tables by the [User] field.
Then we can view as this role , the result is as follows:
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
