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 implement Row level security into one of my reports and wanted some advice regarding a problem that I am currently facing. I have a table with different departments purchases (based on the data from a survey) so that would contain Department Name, Employee First Name and Last Name, Products, Price. And my second table has "Usernames" for each departments, Department Name, ID and Email address.
I connected both the tables using their Department Names ( it is a Many to one relationship).And everytime I try to click on the "Apply security filter in both directions", I get the following error:
My DAX expression from the second table to make the row level security work is:
And it works perfectly when I try to view as using different IDs in the Power BI Desktop, However my report looks completely blank on the server whenever I try to test out a role. Can someone please tell me what am I doing wrong here?
Any assistance would be greatly appreciated.
hi @syasmin25
It should works well, Please try to enter a user in here to test the rls in power bi service:
and you'd better use another account to test it again.
Warning
If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.
Regards,
Lin
Wait, what roles do you have defined?
It is just different views depending on the department viewing the report ( Accounting, Purchasing, Sales, etc.). The head of each department would be able to view the report based on their username. The report is basically for managers of different departments.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |