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,890 points
108 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
• 16,210 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,530 points
848 views
0 votes
1 answer

How to add Row level security?

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

answered Oct 30 in Power BI by ch
• 3,290 points
10 views
0 votes
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,880 points
2,808 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 in Power BI by Avantika
• 1,500 points
162 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,110 points

edited Oct 11, 2018 by Kalgi 208 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
• 41,990 points
98 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 in Power BI by VNK
8,879 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
• 41,990 points
8,556 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
• 16,210 points
136 views
0 votes
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
• 16,210 points
78 views