Dashboards & Reports
Power BI · Dashboards & Reports
Theory
In Power BI a report and a dashboard are different objects. A report is built in Desktop (or the Service) from one semantic model and can have many pages, each full of interactive visuals, slicers, drill-through and bookmarks. A dashboard is a single canvas created only in the Power BI Service by pinning tiles: visuals from one or more reports, even reports on different models, plus text, image, web content or video tiles.
Dashboard tiles are snapshots linked back to their source; clicking a tile opens the report it came from. Dashboards are good for a one-screen executive overview across several reports, and card, KPI and gauge tiles support data alerts that notify you when a number crosses a threshold. Reports are where analysis happens: filtering, slicing and exploring. For example, a CEO dashboard might pin the Total Sales card from the Sales report and the headcount card from an HR report side by side.
Why we use it
Knowing the difference avoids building the wrong thing and is a classic interview and PL-300 question. Each object serves a different audience and level of detail.
When to use it
Use a report for analysis and exploration of one model. Use a dashboard when leaders need a single monitoring screen that combines key numbers from several reports or wants alerts. Many teams publish only reports via an app and skip dashboards.
How it works
- Who is the audience?
- Do they need to explore and filter in depth? Yes: Build a multi-page report. No: Continue.
- Do they need one screen across several reports? Yes: Pin key tiles to a dashboard. No: Share the report via an app.
- Set alerts on important tiles
- Audience gets the right view
Syntax
Report: Desktop → build pages → Publish
Dashboard: Service → open report → hover visual → Pin visual → New/existing dashboard
Pin a whole page: report → ... → Pin to a dashboard
Alerts: dashboard → card/KPI/gauge tile → ... → Manage alertsExample
1. Publish 'Sales Overview' report to the Sales Analytics workspace.
2. In the Service, hover the Total Sales card → Pin visual → New dashboard 'Leadership'.
3. Pin the Sales by Region bar chart to the same dashboard.
4. From the HR report, pin the Headcount card to 'Leadership' too.
5. On the Total Sales tile, Manage alerts → notify when above ₹10,000.
6. Clicking the bar chart tile opens the Sales Overview report page.Key points
- Reports: multi-page, interactive, built from one semantic model
- Dashboards: single page of pinned tiles, Service only
- Dashboard tiles can come from different reports and models
- Data alerts work on card, KPI and gauge tiles
- Clicking a tile opens the underlying report