cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
Super User III
Super User III

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
Highlighted
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Super User III
Super User III

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

Highlighted

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).

Highlighted

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

Highlighted

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

Highlighted

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.

Highlighted

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.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors