Forum Discussion
Row Level Security and Licensing
I am implementing row level security based on UserID. I've created a measure (User = Username()) and then created a role called MyAssignments ([User] = Username()). This seems to be working fine except for anyone outside the organization. When I share this with someone outside the organization Power BI will not allow me to add that persons email address to the MyAssignments role.
Can someone explain:
- What are the licensing requirements for internal users and external users when using role based security? I'm understanding that all the internal users would have to have a power bi pro license which seems riduculous because all they are doing is viewing the reports they don't create any visualizations etc.
- Is there a different way to do this other than using role based security?
- Can external users be added to role based security? If so how is that done? If not, do all my external users have to have a doman Office 365 account and be given access to the Power BI application.
The request is simple just show only report items related to that user but when I tested it with one of the users it prompted them to get a 60 day pro license.
Thanks for your help
2 Replies
Any report that uses Pro features, users that view it must also have a Pro license. RLS is a Pro feature.
Here is a blog post on a different approach to RLS that may or may not help:
As for external users, one way that I have gotten around this is to invite external users to a SharePoint site. In this way, they create a "stub" account in your Active Directory that is tied to their external Microsoft "Live" account. You can then add that "stub" account as one of your members in your RLS group.
