cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andres6and8
Frequent Visitor

How to implement basic row level security to filter an employee's statistics?

Hello. I have a reasonably straightforward project/goal/task:

 

I have a table set up in PowerBI Desktop that looks like so:

example_chart.PNG

 

 I'd like to publish and embed it onto my company website, which is no problem. However, I'd like to set the visual embedding up so that whichever employee logs onto the company website (via Windows login credentials), they'd only be able to see their row. For example, Lady Gaga Lay D. Gagah would only see this upon logging into the website:

 

example_chart_2.PNG

 

To do this, I know I have to use the "Row Level Security (RLS)" feature. The problem is that I have no idea how to begin- most of the resources online only discuss more advanced/technical operations. I tried setting up a rule in the RLS tab, but I could only do it for individual employees by specifying the DAX code to say: 

'Table1'[Employee Name] = "Value"

Obviously, this solution wouldn't be feasible for a company of roughly 3,000 employees.

 

Could someone help me set this up? I have access to PowerBI Pro, Server, and Desktop. Thank you in advance.

 

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

I think you are referring to publish to web, not embed (although technically you ARE embedding a visual into a web page).  Power BI Embedded is used to embed into applications.  Publish to web has no security capabilities built into it, so you will not be able to implement RLS.  RLS is supported within the service though, so if the consumers of content have Pro licenses (or the org has the new Premium sku), you could potentially implement RLS and map the user names/login to their user principal name which will allow them to only view the relevant content when they log into app.powerbi.com

View solution in original post

3 REPLIES 3
dkay84_PowerBI
Microsoft
Microsoft

FYI using PBI embedded for internal users is forbidden unless all users in the org have a pro license.  With the new Premium sku announced this week, you may wish to speak with your IT dept. about this option to have org-wide consumers of content with only a few Pro users (like yourself).

 

When you say you have access to PBI Server, are you referrering to the new PBI Reporting Server for on prem publishing?

Hello dkay84_PowerBI, 

 

I've already implemented a different chart in PowerBI and embedded the chart onto the company's website. Currently, everyone can view that chart- all I'd like to do is embed another one on a different page within the website, and have the user only see their entry.

 

By "PowerBI Server," I meant to refer to app.powerbi.com, the webpage that I'm taken to when I click "publish" in PowerBI Desktop. From there I schedule (up to 8 times per day) a data refresh, which is then reflected in the report on the company website. My apologies if I've messed up the nomenclature. 

I think you are referring to publish to web, not embed (although technically you ARE embedding a visual into a web page).  Power BI Embedded is used to embed into applications.  Publish to web has no security capabilities built into it, so you will not be able to implement RLS.  RLS is supported within the service though, so if the consumers of content have Pro licenses (or the org has the new Premium sku), you could potentially implement RLS and map the user names/login to their user principal name which will allow them to only view the relevant content when they log into app.powerbi.com

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors