cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerbieng
New Member

Row Level Security - External User

Hi Everyone,

 

We published our report in Power BI Service and will share the report with external users. How RLS security can be implemented for an external user.

 

If we add external users details into tables(like normal users) and using USERPRINCIPALNAME() will work?

any other configurations required?

 

Please guide us.

 

Thanks 

 

 

 

 

Thanks

Venkat

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

You would first need to add the external user as part of your AAD, and then assign them access to your dataset, by going into the dataset settings and then clicking on Security.

Here are more details on how to do this. Scroll down to the section, which will explain how to achieve this.

https://docs.microsoft.com/en-us/power-bi/whitepaper-azure-b2b-power-bi#case-study-building-a-bi-por...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

7 REPLIES 7
GilbertQ
Super User
Super User

Hi there

You would first need to add the external user as part of your AAD, and then assign them access to your dataset, by going into the dataset settings and then clicking on Security.

Here are more details on how to do this. Scroll down to the section, which will explain how to achieve this.

https://docs.microsoft.com/en-us/power-bi/whitepaper-azure-b2b-power-bi#case-study-building-a-bi-por...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Hello,

Will they require to have Power BI Pro License?

 

We are dealing with an issue here, hence the questions.

 

We have publised a report using our Power BI Pro license, to 15 users in our organization.

 

Some of the users (out of the 15) have Power BI Pro license, and they are able to view the shared report.

User who do not have the Power BI Pro Licesne, they are unable to view the report,

 

What should be done?

Thanks

Jayanti V Badamwala

Yes, it does require some sort of PBI license.  Either backed by Premium capacity or Pro licenses for internal users.  The customer can have their own Pro license as well.

if it's pointed to Azure Analysis services you need to use CustomData(), but if you were using SSAS on premise, then it's UserPrincipalName, just the format/syntax of the external user is different for Azure AD vs AD (FYI).

Hi there

I would just like to correct if you are using SSAS On Premise it does not know or understand the UserPrincipalName() and only works with Domain\UserName

If you do have an SSAS On Premise database, then you need to use the mapping feature in the Gateway configuration.

If you are using Azure Analysis Services, then it will understand and you can use the UserPrincipalName()




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Actually, we do not map any user when using SSAS.  We use email, which is equivalent to UPN.  We have been working with customers since 2016 on SSAS and also using AAS custom data.

Greg_Deckler
Super User
Super User

Should work using USERPRINCIPALNAME although there may be a slightly different format to that.


@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors