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
• 6,910 points
182 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,040 points

Related Questions In Power BI

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,590 points
1,740 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,380 points
55 views
+1 vote
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

answered Sep 19, 2018 in Power BI by Nilesh
• 6,960 points
4,064 views
0 votes
1 answer

How To use R Integration in Power BI?

Hi,  There are a lot of packages available ...READ MORE

answered May 2, 2019 in Power BI by Avantika
• 1,500 points
565 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,200 points

edited Oct 11, 2018 by Kalgi 473 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
• 51,850 points
203 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 22, 2019 in Power BI by VNK
13,408 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
• 51,850 points
17,895 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,040 points
240 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,040 points
116 views