Forum Discussion
Row level security and relationship
Hi jdusek92 ,
Based on my research, it is due to your relationship will result in a circle filtering that Power BI will not let to create a full circle of relationships between tables due to ambiguity in filtering.
Reference:
Regards,
Daniel He
Hello v-danhe-msft , thank you for your research. the reference is very helpful, but still:
I understand that I cannot create circular relationships like you show show in the picture.
According to your reference it is recommended to use a Star Schema:
In my opinion I am using this type of schema, I do not have any circular relationships:
Yet I cannot use RLS filtering from EMPLOYEES table to filter BOTH look-up tables (JOBS and CHAIRS). I can be set to filter only one at a time. I need all the related tables to be filtered by RLS
Example pbix is attached here:
https://drive.google.com/open?id=1Y0sYDcSULkRQGpYWv9nfMzaOVzWFrozo
Try view as role:
Maybe this is a limitation of Row Level Security / Roles ?
Regards,
Jakub
jdusek92 you added 4 seperate tables and viewing them seperately. You dont visualize data like that right.
Just add columns from all 4 tables into one table(visual) and see.....
HI,
I have the same issue. Did you get any solution on this
To be sure, I include a UserPrincipalName column in each table and set up a role filtering for each table. Also I eliminate the tables that cannot be enriched with UPN column (like Job Catalog) - data from such tables must be therefore merged+expanded to main datatables. Otherwise I cannot be sure that unwanted information will be hidden.