Power BI Azure AD Users and Groups Dashboard

Collaborating with external users can be challenging, and it's important you do not lose them as part of their on-boarding process into your Microsoft 365 tenant. Power BI Azure AD Users and Groups Dashboard is an open-source common code base of intellectual property created by Envision IT. The Users and Groups Dashboard enables organizations to gain insight into what is happening with their groups and users that exist within Azure AD.

To view the full documentation on this open source solution click the button below to download our technical guide:

For IT Administrators, troubleshooting issues that arise for users in the sign-in process can be a tedious process; finding the source of the issue is challenging, as it could stem from any of the following:

  • User error
  • User's organization has a mis-configured tenant
  • Conflicting tenant configuration settings
  • Permissions issue

These issues can manifest in different ways and occur at different points in the sign-in process, which adds to the challenge of manual troubleshooting. When managing external users' access to shared resources within your organization's tenant, these inconveniences are almost unavoidable due to the nature of dealing with identities of varying domains, all of which have unique security settings and permissions. Configuring Azure AD External Identities to best suit your organization's needs is a good starting point, however the issue may not always be on your tenant's end, as pointed out in the previous list.

Any of the above issues would be frustrating for the user and could impede their ability to work effectively or obtain the resources they need to complete a task. The most effective way to mitigate these inconveniences is to implement a Power BI Dashboard that will quickly enable you to identify:

  • Member and Group Activity within Azure AD with ability to drill down into user and group type
  • User sign-ins
  • Sign-in failures
  • Group and user details
  • User issues

This can empower customer support teams who may not have access to Azure sign in audit logs to adequately support their users signing in to the tenant, rather than waiting on IT administrators to provide insight into potential sign in issues a user may be experiencing. This Power BI dashboard saves users valuable time while also maintaining control over the environment.

The main components of the solution include:

  • Console app to harvest Azure AD audit logs
  • Azure Storage account for log management
  • Power BI Dashboard for Azure AD users and groups visualizations