10.3 Dashboards and Advanced Distribution

Key Takeaways

  • Dashboards are single-page canvases built only in the service by pinning tiles from reports, Q&A, Excel, and streaming data.
  • Clicking a tile pinned from a report navigates to the source report page with filter context; a tile with a custom link jumps to the configured destination.
  • Data alerts, the integrated Q&A box, and Feature on Home (default landing dashboard) are dashboard-only features not available on reports.
  • Publish to web creates a public, unauthenticated URL where RLS is NOT enforced - it must never be used for sensitive or internal data and requires admin enablement.
  • Distribute via apps (broad), sharing (targeted), subscriptions (automated), or embed in SharePoint/Teams; Power BI Pro allows 8 scheduled refreshes/day and Premium 48.
Last updated: June 2026

Quick Answer: Dashboards are single-page canvases in the service that pin tiles from many reports, Q&A, Excel, and streaming sources. Clicking a tile navigates to its source report with filter context. Dashboard-only features include data alerts, the integrated Q&A box, and Feature on Home. Distribute content through apps (broad), sharing (targeted), subscriptions (automated), and embed (external) — and use Publish to web only for genuinely public data because it needs no authentication.

Dashboard design

Good dashboards monitor a few key metrics at a glance: lead with KPI tiles at the top, keep roughly 5-10 tiles, align tile sizing, add text tiles as section headers, and set custom tile links so a tile can jump to a specific detail report or URL.

Tile types

TileSourceUse
Report visualPinned from a reportMost common — any visual
Live report pageWhole page pinnedFull interactivity in a tile
Q&ANatural-language resultQuick ad-hoc answers
Web contentHTML/iframeEmbed external content
Image / Text box / VideoUploaded/typed/URLBranding, headers, training
Streaming dataReal-time sourceIoT/live metrics tiles

Dashboard-only features

  • Data alerts on card/gauge/KPI tiles (threshold notifications) — not available on reports.
  • Q&A box at the top: type a question, get a visual, and pin it as a new tile.
  • Feature on Home (More options -> Feature on Home): sets the default landing dashboard for the workspace.

Tile click behavior

Clicking a tile that was pinned from a report navigates to the source report page with the relevant filter context, so consumers move from glance-level monitoring into full interactivity. (A tile with a custom link instead jumps to the URL/report you configured.)

Advanced distribution

SharePoint Online: Report -> Embed -> SharePoint Online, copy the URL, and add the Power BI web part to a page (viewers still need Power BI access and a license/Premium capacity). Microsoft Teams: add a Power BI tab to a channel and pick the report. Power BI REST API: automate refreshes, exports, permissioning, and CI/CD-style deployments.

Publish to web (public)

Report -> Embed report -> Publish to web (public) generates a public embed code and URL.

Warning: Publish to web is public and unauthenticated — anyone with the link can view and even reshare the data, and it can be indexed by search engines. Never use it for sensitive, confidential, or internal data; RLS is not enforced. A tenant admin must enable the feature, and it is blocked for content with sensitivity labels that prohibit it.

Dashboard vs. report: the full comparison

The single most-tested idea in this section is the dashboard/report distinction, so internalize the whole table:

CapabilityDashboardReport
PagesOne canvasMultiple pages
Built wherePower BI Service onlyDesktop or Service
Data sources per itemTiles from many models/reportsOne semantic model
Slicers / filtersNo (tiles are static snapshots until clicked)Yes (full interactivity)
Drillthrough / bookmarksNoYes
Data alertsYes (card/gauge/KPI tiles)No
Q&ABuilt-in boxQ&A visual you insert
SubscriptionsYesYes
Featured / landingFeature on HomeNo

The mental shortcut: a dashboard is a single-page monitoring wall that aggregates pinned tiles from across reports; a report is a multi-page interactive analysis bound to one model. Alerts and Feature-on-Home are dashboard-only; slicers, drillthrough, and bookmarks are report-only.

Distribution method decision guide

When a scenario asks "how should this be delivered," match audience to method:

ScenarioBest method
Hundreds of read-only consumers org-wideApp (on Premium/Fabric so free users can view)
A few colleagues co-authoringWorkspace sharing with appropriate roles
One stakeholder needs a weekly PDFSubscription
Embed inside a Teams channel or SharePoint pageTeams tab / SharePoint web part
Embed in a custom internal portalEmbed (app-owns-data / user-owns-data) via the API
Truly public, non-sensitive data on the open webPublish to web

Publish to web: the security rule the exam hammers

Publish to web is the one feature where a wrong choice is a security incident. It produces a public, unauthenticated URL and embed code; anyone with the link sees the data, it can be indexed by search engines, RLS is not enforced, and consumers can reshare freely. It must be enabled by a tenant admin, is blocked for content carrying sensitivity labels that prohibit it, and should be used only for data intended for the general public. Any scenario involving internal, confidential, or PII data and "embed for external/anonymous viewers" must use secure embedding, not Publish to web.

On the exam

Expect: identify a dashboard-only capability (data alerts, Feature on Home) versus report features (slicers, drillthrough, bookmarks); predict tile-click behavior (navigate to source report with filter context); choose the distribution method that fits the audience; flag Publish to web as public/unauthenticated, RLS-not-enforced, and unsuitable for sensitive data; and recall the 8 (Pro) / 48 (Premium) scheduled-refresh limits that often appear alongside distribution questions.

Test Your Knowledge

Which of the following features is available ONLY on dashboards, NOT on reports?

A
B
C
D
Test Your Knowledge

A dashboard tile shows revenue from a pinned bar chart. When a user clicks the tile, what happens?

A
B
C
D
Test Your Knowledge

Your company wants to embed a Power BI report on a public-facing website for non-authenticated visitors. What security consideration is most important?

A
B
C
D
Test Your Knowledge

How many times per day can a Power BI Pro dataset be refreshed via scheduled refresh?

A
B
C
D