Forum Discussion
Relative Date Slicer Blank with Row Level Security Role
Super UserI am going to assume that the date column is on the table that is being filtered by the RLS
Do you have a separate Date table?
If not I would suggest creating the Date table, which I am fairly certain would solve your issue.
Thank you GilbertQ for your reponse, I really appreciate your help!
To paint a better picture of my desktop build, I have three tables loaded into Power BI. A Date dim table, a user lookup table, and a data table. The User Lookup table does not have a date in it and is connected to the Data table by key user identification code, other than their user principal name (RLS field). The Date Dim table is connected to the data by post date. There is no direct connection to the User Lookup table and the Date Dime table.
I was looking at the table relationships and the Date Dime table is the only one that has a one to many cardinality with a cross filter direction of both. The Data table and the User Lookup table is connected by a many to many cardinality with a cross filter direction of both. Could this be the issue? Should there be an inactive relationship between the User Lookup table and the Date Dime table?
Here is the Data Table and the User Looup Table relationships:
Here is the Date Dim table and the Data Table relationships:
Again, thanks so much for your help!
- GilbertQHi there
Could I ask why there the cross filter is set to both between the Date and Data table?
That would certainly be causing the issue with regards to the RLS.
Change it to One to Many and see if it then works?