cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aaroh_bits
Regular Visitor

Power BI Office 365 Adoption content pack query

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

    Power Automate Premuim Acciunt.jpg

  • 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? 

  • QDo we need to use Microsoft Graph if at all is required for this requirement?

 

Any advice would be highly appreciated

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi , @aaroh_bits 

  • 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 adminExchange adminSkype for Business adminSharePoint adminGlobal 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-analyt...

  • 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...

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

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

 

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.

 

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @aaroh_bits 

  • 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 adminExchange adminSkype for Business adminSharePoint adminGlobal 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-analyt...

  • 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...

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

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

 

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.

 

View solution in original post

aaroh_bits
Regular Visitor

@nickyvv 

@GilbertQ 

 

@V-lianl-msft 

please advice. 

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors