Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
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
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.
But these stub accounts need a Power Bi Pro licence aswell, or am I wrong?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
29 | |
28 | |
22 | |
22 | |
19 |
User | Count |
---|---|
53 | |
36 | |
28 | |
24 | |
21 |