Power BI Office 365 Adoption content pack query

[Anonymous]

Hi All, 

Business Requirements  

• A business users intends to use different 5 domains (for different countries) with an Office 365 Tenant with E3 subscription . 
  
  
• The user wants to gets adoption / usage report for all 5 different countries such as 
  • Adoption overview for each month for each country such as EnabledUsers, ActiveUsers etc. 
  • Returning Users for each country. 
  • Mailbox count for each  country. 
  • OneDrive, SharePoint Storage for each  country. 
  • Active user count by product and user location etc. and some other reports. 
    
    
• The user is using Power BI Free edition to use this usage report.

Challenge: 

• User is prompted with Power Automate Premium as follows
  
  
  
  
• Q: Does this user requires Power Automate  licence to use Power BI report? 
  
  
• Q: Is it possible to extend Power BI Office 365 Adoption content pack for different countries ( domains ) to get usage reports or what is best practice to display user reports and adoption if we start from scratch Power BI service? 
  
  
• Q: Do we need to use Microsoft Graph if at all is required for this requirement?

Any advice would be highly appreciated

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

• Microsoft 365 Usage Analytics, previously named ‘The Office 365 Adoption Content Pack’, takes service usage data and user metadata to provide a host of analytics for measuring levels of user adoption across your cloud services such as SharePoint , Exchange, Teams and Skype for Business etc.
  To share the usage analytics report, both the person sharing the report and the recipients just require a Pro licence to share and view the results.
  And you have to be either a Global admin, Exchange admin, Skype for Business admin, SharePoint admin, Global reader or Report reader in order to establish the connection to the template app. 

• The data model that powers the template app includes user attributes from Active Directory, enabling the ability to pivot in certain reports. The following Active Directory attributes are included: location (such as location city ,location country), department and organization. If you  want to  show country information in the report, please refer to following post to customize the reports in Microsoft 365 usage analytics. However,user specific information is available for the last full calendar month.
  https://www.loryanstrant.com/2020/01/27/adding-country-based-filtering-to-microsoft-365-usage-analytics/
  
  
• Additional customization on this data is possible by connecting to the Microsoft Graph reporting APIs to pull additional fields from Azure Active Directory and join to the dataset.

For more details ,please refer to these  related documents :

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/usage-analytics-data-model?view=o365-worldwide

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/usage-analytics?view=o365-worldwide

https://tomtalks.blog/2018/07/microsoft-365-usage-analytics-new-free-power-bi-office-365-usage-reports-from-microsoft/ 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@nickyvv 

@GilbertQ 

@V-lianl-msft 

please advice.