How to get the Copilot usage report in detailed from M365 admin center and pull it in Power BI for visualization as the current report which is shown in M365 admin seems not clear and it does not give clarity?

@Mytoast Admin - To get a detailed Microsoft 365 Copilot usage report from the M365 admin center and visualize it in Power BI, you can follow these steps:

1. In the M365 admin center, navigate to Reports > Usage. Select the Microsoft 365 Copilot page and then the Usage tab to view adoption and usage metrics.
2. You can export the report data into an Excel .csv file by selecting the Export link on the report page. This will allow you to download the data for further analysis.
3. Open Power BI Desktop and go to Get Data > Other > OData Feed. Enter the URL for the OData feed, which is typically in the format: https://reports.office.com/pbi/v1.0/<tenantid>. Follow the prompts to connect to the data source and load the data into Power BI.
4. Once the data is loaded, you can create various visualizations to better understand the Copilot usage metrics. Use Power BI's visualization tools to create charts, graphs, and dashboards that provide clarity on the usage data.
5. Customize the reports to focus on specific metrics such as active users, enabled users, and feature usage. You can filter the data by different periods (e.g., last 7 days, 30 days, 90 days) to get more granular insights.

Ref Docs:

• Microsoft 365 Copilot Usage Report
• Customize Reports in Microsoft 365 Usage Analytics

Thanks, 

Nivedipa

************************************************************************* 

If the response is helpful, please click "Accept Answer" and upvote it. You can share your feedback via Microsoft Teams Developer Feedback link. Click here )to escalate.