Forum Discussion
How to implement basic row level security to filter an employee's statistics?
- 9 years ago
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
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.
- dkay84_PowerBI9 years agoMicrosoft Employee
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