Forum Discussion
Solved
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 deta...
- 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-portal-using-power-bi--azure-ad-b2b--step-by-step-instructions
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).
GilbertQ
Super User
Super UserHi 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()
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()
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.