Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am trying to create a dashboard based on the following scenario
Data
https://drive.google.com/file/d/19W6kqK5D9QLoBjoL6DgGQ3j_LdF2hsYr/view?usp=sharing
I tried creating relationships and setting filters under manage roles but nothing seems to work...either I see all data or don't see any data while toggling through view as option.
Can anyone help me with this.
Solved! Go to Solution.
HI @Anonymous ,
Can you please refer my last reply on using USERPRINCIPALNAME() instead of USERNAME() in accordance with the article link.
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution!
Thanks,
Pragati
@Anonymous - Also refer to this RLS playlist on youtube which might help to resolve your problem.
https://www.youtube.com/playlist?list=PLRKSzkvyfSLe2gZagN8DYnXiLMV52jDp9
BR,
- Pavan M.
See the blog below for better RLS clarity. You also have knowledge details in the user table as well.
@Anonymous ,
Refer the below blog for better clarity of RLS. Also it has details knowledge on Users table also.
@Anonymous , see if these can help in RLS
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
Hi @Anonymous ,
It will nice to have a screenshot around what type of relationships you are creating between your data table and User table.
Also, can you paste the DAX you are using to apply RLS?
Thanks,
Pragati
Hola Pragati,
Here's what I tried... but it doesn't seem to work
Hi @Anonymous ,
I have such a table.
Then I create a role like this( [Email_Address] column contains the email account.).
Then View as the role.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello @v-lionel-msft
Thanks for looking into this. I tried settin it up as suggested and seems to be working on my system. However when I publish it to my workspace and share it with my colleague he's seeing this. I have given read access to report as well as dataset but still this comes.
HI @Anonymous ,
Can you please refer my last reply on using USERPRINCIPALNAME() instead of USERNAME() in accordance with the article link.
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution!
Thanks,
Pragati
Hi @Pragati11
I had tried that as well...I initally tried with Username() to check against my id field and since that didn't work, i tried USERPRINCIPALNAME() to fetch the email id of the user...both were giving the same issue
@Anonymous - IS your ID field contains Email Addresses of the users? otherwise, try [Email]=USERPRINCIPALNAME() to have the RLS work properly.
BR,
- Pavan M.
HI @Anonymous ,
Ok and did you try refrerring to the article link I shared? Your scenario looks very much similar to the example in that link.
Thanks,
Pragati
HI @Anonymous ,
Glad that worked for you.
If it helped can you mark it as a solution for others to refer in future?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @Anonymous ,
Can you please check your DAX expression as it doesn't look right? I think you should use USERPRINCIPALNAME()
Please refer following article to implement RLS in your scenario:
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |