RLS on DirectQuery
Greetings everyone! I'm having trouble configuring the RLS for my report. I've searched several sources on youtube, but nothing has been able to help me. At first I have 2 tables: And I configured the RLS as shown in the image below: When I use EmailBP from BPs por Entidade table in a slicer, I can filter PEOPLE VW_FACT_INDI table normally. However, when I simulate the role in RLS, BPs por Entidade is filtered, but PEOPLE VW_FACT_INDI is not. Why is that? How can I solve this problem? Best Regards,
Need help setting up Role using USERPRINCIPALNAME() with an extra parameter
Hello everyone! I created a Role where a Partner could only see their own Engagements by using the USERPRINCIPALNAME() measure. It is as follows: If he is a Lead Eng. Partner or and Eng. Partner or and Associate Partner, he should be able to see the Engagement he is a part of. In the following example, Partner B is an Eng Partner for the Engagement 3000431234, so he should see that row. The way I have set up, he can only see the rows his username shows up. However, in this case he would need to be able to see the other Engs. as well because one of the Engagements he is part of is in the Lead Engagement 2001401234. In cases where neither of these two conditions apply, he should not be able to see either the Eng. nor the Lead Eng. Lead Engagement Engagement Lead Eng Partner Email Eng Partner Email Associate Partner Email 2001401234 3000431234 [email protected] [email protected] n/a 2001401234 3000401555 [email protected] [email protected] n/a 2001401234 2001401234 [email protected] [email protected] n/a And that is where I'm having trouble setting up, because in some cases such as this one, the partner isn't in either of those three email fields, but because he is part of the Lead Engagement, he should also be able to see them as well. Any help is appreciated! Thanks!HELP Please: Show the Data But Not All the Details (Data Filtering Based on USERPRINCIPALNAME?)
Hello, I have a table that shows production and I would like all employees to see everyone's production but only see their own name (the rest of the names should be blank). This I have achieved using this DAX below. However, if the user logged in is a supervisor (the Employees table has a Supervisor column with a Yes or No value), there should be no filters and he/she should see all data. In the screenshot below, if Princess Leia is a supervisor, she should see all the Employee Names. Also, the supervisor may or may not have production numbers in the table. Any suggestions for how to do this? I would appreciate any help please. EmployeeName = IF( SUM('Production'[Quantity]) && SELECTEDVALUE('Employees'[LogInEmail])=USERPRINCIPALNAME(), SELECTEDVALUE('Employees'[Name]) ) Here's how it looks - Darth Vader is the user currently logged in. After I took this screenshot, I made Darth Vader a Supervisor and I want all the Employee Names to display instead of just his own name. Data tables: Employees: Production: I thought about maybe having a separate Supervisor table that contains a list of supervisors? Thanks in advance!
