use Power BI s Row Level security to implement employee filter

0 votes
I'm trying to embed Power Bi scorecard visual on the company website. I want employees to login into the website using their credentials and they should be able to see only their details. I'm not sure how to go about this when it comes to security purpose. A little help would be useful. Thank you ..
Oct 22, 2018 in Power BI by shubham
• 7,340 points
1,034 views

1 answer to this question.

0 votes

We also have a similar feature in our company but we directly view the scoreboard on the power bi service itself. 

The basis for this form of dynamic row level security is that the expression written is evaluated for each row in the indicated table to either True or False.

If your user has signed in to the you will be able to determine the identity using USERPRINCIPALNAME(). This is the email address they use to sign into the service.

Since you are displaying data specific to that user, it is possible you already have their email in your data. If that is the case, and it is simply another field in your table your validation line would look something like:

'Table1'[Email] = USERPRINCIPALNAME()

The left side of the expression refers to the row you are referencing, while the right will supply the name of the authenticated user.

answered Oct 22, 2018 by Hannah
• 18,540 points

Related Questions In Power BI

0 votes
0 answers
0 votes
1 answer

How do I implement row-level security (RLS) in Power BI using DAX?

Suppose you are considering sharing your Power ...READ MORE

answered Oct 21 in Power BI by pooja
• 1,220 points
53 views
0 votes
1 answer

Row Level Security not applied through LOOKUPVALUE in Default filter

I see what you mean now. LOOKUPVALUE appears to ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,620 points
5,422 views
0 votes
1 answer

How to add Row level security?

To add Row Level Security, Follow the ...READ MORE

answered Oct 30, 2019 in Power BI by ch
• 3,450 points
756 views
+3 votes
2 answers

Combine tables in Power BI

You can also achieve this using a ...READ MORE

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,421 views
0 votes
1 answer

Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
1,137 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

answered May 23, 2019 in Power BI by VNK
18,894 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
37,589 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,540 points
1,464 views
+1 vote
1 answer

Is it possible to manage limits while using dedicated capacity power bi embedded app service?

These limits are not related to using ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,540 points
685 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP