Forum Discussion
AD groups in Power BI (Office 365) groups
Anonymous
Is this a possibillity today? No
If not, will it be in the future? Don't know
If not, what is the "best practice" solution in this case? My typical approach is to use Group workspaces to organize departments of Report Authors and use them as the central point to share reports with end users. In this manner, you can share a dashboard with an AD group with no issues, and the reports are all managed in one location.
As opposed to creating a seperate Group Workspace for a set of individuals. This also includes the problem that now the end user has to hunt around several Group Workspaces to try to find reports if they belong to several Groups. Whereas with the first approach and good naming standards, everything is in their workspace to be viewed.
Anonymous Yes. I don't want to be in the business of User management in Power BI.
If I want to share a dashboard to 100 users, let the access be dictated by IT and AD.
Microsoft EmployeeHi hargel,
I would add some additional information here.
When saying AD group, I think you means security group in AD. There are three types of groups defined in O365, Office 365 group, Security Group and Contact group (known as distribution list, used to send emails). Groups in Power BI refer to Office 365 group, which is different from the other two. Office 365 group owns a special tenant(used for online services) which is used to store the related items used for sharing and the other stuffs.
For Security group in Active Directory, the related information is stored in Active Directory(synced to O365), which currently is not supported for Power BI.
To manage groups(configure) in Power BI, we need to access O365 Admin center.
Regarding Power BI management under organization, please check:
Administering Power BI in your organization
About the Office 365 admin center
If any further assistance needed, please post back.
Regards
Hi v-micsh-msft,
You're correct, that is what I meant. But as I understand it now, groups in Power Bi doesn't support security groups in AD. However, you can share a dashboard with a security group in AD. That is the reason behind Anonymous's solution.
Please correct me if I'm wrong. We will ha lots of users and are looking for the best solution both in terms of handling security and user experience.
BR
Martin
- v-micsh-msft
Hi hargel,
If we have synced the AD security group, we might see it under Office 365 admin portal, however can't manage the group in Office 365.
To share dashboard with the email address of a distribution group is available, but it requires we use Office 365 for email, and the distribution group is defined under Office 365. Check:Share a dashboard with colleagues and others
Although sharing with the AD group would show no errors under Power BI, group members will not receive any email remindings of a shared dashboard. Only sharing to the personal email address will the reminding email be successfully sent.
Regards
Thanks,
I will test everyting out soon. We do have Office 365 for mail and can use groups there with workspaces in Power BI.
However, we do control access using AD security groups, both source system and cube access, therefore it would be convinient to use that in Power BI.
I'm not 100 % sure what you mean with "show no errors", if it will work or not, but I will try it out to see how everything works in our setup.
Hi,
Anonymous were you able to test everything. Can you please share your findings.
Thanks
