Microsoft Teams Dataset - Import Teams Activity Data


This is a dataset template to extract and store Microsoft Teams information and usage data for faster and more comprehensive reporting.

In addition to usage by templates published within Voleer, you can also connect Power BI directly to this dataset for visualization and reporting.

How it works

This template imports the following information from Microsoft Teams and Azure AD into the dataset:

  • Teams usage reports (number of private and channel messages, number of 1:1 calls and meetings, devices)
  • User name, job role, department and location
  • Details of Teams including membership, number of channels, files and last activity


Permission Requirements

If using Microsoft 365 credentials

To run this, you will require a M365 account with Global Admin rights to

  • Create an application registration
  • Assign admin-consent application permissions

If using Microsoft Partner credentials

To run this, you will require a Partner account with Global Admin rights to

  • Create an application registration
  • Assign admin-consent application permissions

If channel messages and message reply information is required, a M365 account with Global Admin, Cloud Application Admin or Application Admin rights on the target tenant is also required

Getting started

  1. Sign in to your Voleer account or sign up for a new account

  2. On the Library page, select template Microsoft 365 Dataset - Import User Teams Activity Data

  3. Read the Requirements and configure your account(s) and tenant as stated

  4. Once configured, along the right hand side, select a Workspace, then click on Create

  5. Provide a Dataset name and Description (Optional), then click on Continue.
    TIP - For easy reference, putting in the tenant domain name as the dataset name will help with managing your dataset

  6. Authorize Access to Microsoft Graph by 1) Copying the code, 2) Visiting the link and completing the authentication process, and then 3) Clicking on the Validate button

  7. Choose whether to enable the Simple Replay Option, then click on **Submit

  8. Select if admin consent should be granted. By providing admin consent, access to channel messages and replies by granted to Voleer to help determine Teams activity. Complete the subsequent authorization forms if admin consent should be granted.

  9. Configure the dataset template by filling out the Retention Period section. Note - by using the defaults, it will have a retention period of 1 year.
    Once completed, click on Validate Template Configuration.

  10. Select the notification method and email addresses of recipients who should receive notifications on the changes to the dataset. These notifications include information such as the number of new and deleted records and links to useful information.
    Click on Validate Template Configuration

  11. Review the configuration on the Summary page, then click on Acknowledge and Create Dataset.
    Congratulations, the Microsoft Teams Activity Dataset is now being provisioned!
    Depending on the size of your tenant, it may take some time to populate the dataset for the first time. But note that subsequent refreshes will be a fraction of the time!

  12. By default, the dataset is configured to be refreshed on a daily basis at 12:00 AM UTC. If you rather update the refresh to occur during non-business hours, click on Change Schedule and update the timezone and time value.
    TIP - Keep the Repeat at daily to ensure data doesn’t get stale within your dataset

Have an issue?

Post a comment in this article and someone will get back to you as soon as possible