Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello community!
I have a model, which I need to filter by user and year; However, when I configure my RSL it does not filter my data.
As you will see in the image, I have created a filter where I have 2 conditions, if the user who logs in is different than "mailadmin@mydomain.com" the data should be filtered and only the information from 2023 onwards should be shown, but, When I validate this it does not filter the years and continues to show all the years.
Could you tell me what I'm doing wrong?
Thank you!
Rgds,
DC
Solved! Go to Solution.
Hi @DanCasSan20 ,
If a user has permissions for multiple roles at the same time, his permissions are the union of multiple roles.
So, when testing, you should only choose one roles.
And, you can try below RLS expression on DIM_TIMEPO:
IF(USERNAME()<>"mailadmin@mydomain.com",TRUE(),'DIM_TIMEPO'[Year]>=2023)
Also, you can enable security filtering options when establishing relationships.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Hi @DanCasSan20 ,
If a user has permissions for multiple roles at the same time, his permissions are the union of multiple roles.
So, when testing, you should only choose one roles.
And, you can try below RLS expression on DIM_TIMEPO:
IF(USERNAME()<>"mailadmin@mydomain.com",TRUE(),'DIM_TIMEPO'[Year]>=2023)
Also, you can enable security filtering options when establishing relationships.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
User | Count |
---|---|
88 | |
87 | |
73 | |
66 | |
57 |
User | Count |
---|---|
129 | |
102 | |
91 | |
83 | |
67 |