Average number of datasets per dashboard - Power BI SQL Query - Peliqan

Average number of datasets per dashboard

SQL query for Power BI

Calculate the average number of datasets used in each dashboard.

SELECT AVG(num_datasets) FROM (SELECT dashboard_id, COUNT(dataset_id) AS num_datasets FROM datasets GROUP BY dashboard_id) AS subquery

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.