Top 5 reports by usage
SQL query for Power BI
Find the top 5 reports based on the number of times they have been accessed.
SELECT report_id, COUNT(*) AS access_count FROM reports GROUP BY report_id ORDER BY access_count DESC LIMIT 5
Power BI data model
Reports
Apps
Groups
Dashboards
Datasets
Dataset Users
Table Rows
Tables
Columns
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed