Reporting on number of users viewing a report by day, by user id in each workspace

[rammy_rammy]

Objective: I want to analyze the number of users viewing each report and conduct trend analysis on the overall uptake of Power BI in my organization. This analysis should cover all reports across the organization, not limited to specific reports or workspaces.

Goals:

1. Identify the most popular report (most viewed across all workspaces).
2. Determine if specific enhancements have improved report usage.

Data Requirements (for at least 3 months):

• Date
• Report Name
• Workspace Name (optional)
• User ID or email
• Number of views

Current Challenge: The Feature Usage and Adoption report under Admin Monitoring is helpful but does not display data by report—it only shows overall statistics. Additionally, it is currently not functioning.

[pallavi_r]

Hi @rammy_rammy 

The tools that I have used in the past for similar requirement to track report usage and viewers are Power BI usage metrics, Log Analytics, Application Insight.

But somewhere I had read tht usage metrics report will be retired in 2024.

You can check all these via log analytics and build a custom report on top of it as per your requirement.

Thanks,

Pallavi

[Poojara_D12 · Accepted solution]

HI @rammy_rammy 

Enable Audit Logs in Microsoft 365 to capture report-level usage data. Use the Power BI REST API (GetActivityEvents) to extract logs with details like date, report name, user ID, and views. Automate data extraction with a script, process it in Power BI, and create a dashboard to analyze report popularity, trends, and enhancement impacts. Use this as an alternative to the Admin Monitoring report if it's not functioning.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS