cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Security: Add emails that are not in my organization

Hello, I have a problem.

 

On Power BI Desktop, by testing the display functionality as roles, it works.

I created a dynamic role, which grants access to certain data based on the email address with USERPRINCIPALNAME () on Power BI Desktop it works.

 

Unfortunately, I realize that on Power BI Service it does not work. In addition to that, my role is not dynamic anymore (if I believe my research), I have to manually add all the email addresses related to roles when I thought that with USERPRINCIPALNAME (), we did not need to do that.

 

And this is my biggest problem, we can only add mail addresses related to our organization but I create the report precisely so that it is accessible to my clients.

 

Is there a solution ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Security: Add emails that are not in my organization

Hi @geckodead,

 

Based on my test,  even though you use the USERPRINCIPALNAME () on Power BI Desktop, you should also go to security setting of the data set you just published to add users. The advantage of using  USERPRINCIPALNAME () or username() is that you needn’t to add multi roles in Power BI desktop. For example, you create a role using DAX [username] = USERNAME() in desktop and add some related users in the role in service. Then all the members in your group or members affected by this permission to this role. 

 

For the external members, I suggest you to add the user as guest to Azure Active Directory in advance and share the report / dashboard to them. For more details, please check the online document.

 

333.png

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Security: Add emails that are not in my organization

Hi @geckodead,

 

Based on my test,  even though you use the USERPRINCIPALNAME () on Power BI Desktop, you should also go to security setting of the data set you just published to add users. The advantage of using  USERPRINCIPALNAME () or username() is that you needn’t to add multi roles in Power BI desktop. For example, you create a role using DAX [username] = USERNAME() in desktop and add some related users in the role in service. Then all the members in your group or members affected by this permission to this role. 

 

For the external members, I suggest you to add the user as guest to Azure Active Directory in advance and share the report / dashboard to them. For more details, please check the online document.

 

333.png

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Highlighted
Community Support
Community Support

Re: Security: Add emails that are not in my organization

Hi @geckodead,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case please.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors