TL;DR — BI dashboards on screens in 30 seconds
Showing Power BI, Looker Studio, Tableau, Metabase or Grafana dashboards on signage screens is technically trivial: public URL or embed with service account, refresh every 5-15 min, the player's browser shows the URL like any content. The real challenge isn't technical: designing the dashboard for TV (big text, few KPIs, high contrast) and separating the "team dashboard" from the "signage dashboard". Easiest platform for SMB: Looker Studio (free, Google authentication). For Microsoft environments: Power BI Pro with service account. For technical teams: Metabase or Grafana.
In this article
Why put BI on signage screens
BI dashboards traditionally live on managers' and analysts' individual screens. But there's an underused asset: showing operational KPIs on team-shared screens, visible to entire departments or common areas. Three concrete benefits:
- Instant operational alignment. When the whole sales team sees today's KPIs on the shared screen, decisions sync without meetings. If the number is low, the team knows without being told.
- Data-driven culture without meetings. Data is in plain sight, not buried in a monthly PDF. Anyone on the team can glance and see how metrics are tracking.
- Visibility for visitors. Clients or investors walking into an office immediately see "this company measures what matters". Reinforces professional perception.
Typical usage: sales team room, ops room, office reception (showing public brand KPIs), support room showing open tickets and NPS, factory floor showing OEE and output.
Use cases by department
BI platforms compatible with signage
Microsoft Power BI
Dominant in companies already on Microsoft 365. Native integration with Excel, SharePoint, Azure, Dynamics. Powerful visualisations, large community.
Signage modes: "Publish to web" (public URL no auth, public data only), embed with Pro service account (private data, requires Pro licence £8/user/month), Power BI Embedded with API tokens (enterprise).
Google Looker Studio (formerly Data Studio)
Free, no user limit. Native connections to Google Sheets, Google Analytics, BigQuery, MySQL, PostgreSQL. Gentle learning curve. Google Workspace authentication.
Signage modes: dashboard URL with Google auth (service account in player's browser), or public dashboard with non-sensitive data. Native embed support in any signage system.
Tableau (Cloud / Server / Public)
Leader in advanced analytical visualisation. More expensive but more powerful. Three modes: Tableau Public (free, public data), Tableau Cloud (£30/user/month minimum), Tableau Server (enterprise on-premise).
Signage modes: Tableau Public with direct URL, Tableau Cloud with service account + embed URL (format ?:embed=yes&:refresh=yes), Tableau Server with JWT.
Metabase (self-hosted)
Open-source, free, popular in startups. Connects to any SQL database. Simple but powerful UI. Public dashboards shareable via URL.
Signage modes: "Public link" of the dashboard generates URL accessible without auth. Embed with persistent session token for sensitive data. Per-dashboard configurable refresh.
Grafana
Dominant in technical monitoring, infrastructure, IoT, real-time operational metrics. Open-source self-hosted or Grafana Cloud (free up to a usage tier). Specialises in time series and technical dashboards.
Signage modes: native kiosk mode (parameter ?kiosk=tv hides all UI). Per-panel adjustable auto-refresh. Ideal for DevOps, server rooms, industrial dashboards.
Power BI step-by-step setup
Fastest way to show a Power BI dashboard on signage:
- Open your dashboard in Power BI Service (app.powerbi.com). Confirm the page is the one you want to show.
- File menu → Embed report → Publish to web (requires admin enablement). A box appears with public URL and embed code.
- SECURITY WARNING: this URL is public on the internet. Anyone with the link sees it. Use only with non-sensitive data. For private data, go to option 2 (service account).
- Copy the generated URL (format
https://app.powerbi.com/view?r=...). - In your signage software (Digisini, others), create "URL" content type and paste the link. Set duration 30-60 seconds.
- Configure auto-refresh: Digisini has "refresh URL every N minutes". Set 10-15 minutes for typical KPIs.
- Adjust page zoom if the dashboard has small text — some signage systems allow CSS zoom on URL load.
Looker Studio setup (easiest option)
If you have Google Workspace or a personal Google account, Looker Studio is the fastest and free option:
- Open your dashboard in Looker Studio (lookerstudio.google.com).
- "Share" button → "Manage access" → change to "Anyone with the link can view" (if non-sensitive) or keep "Only added users" (sensitive).
- Copy the view link.
- For internal signage with private data: add your service account (e.g.
[email protected]) with "Viewer" permission. Configure player's browser with that account logged in. - In your signage software: create URL content with the copied link.
- Native refresh: Looker Studio refreshes every time the URL is loaded. Configure your signage to reload every 10-15 min.
Tableau setup
Tableau needs slightly more work depending on version:
- Tableau Public (free): publish your workbook as "Tableau Public", get direct URL. Works like any link.
- Tableau Cloud / Server (private): the workbook URL needs embed parameters. Format:
- Create service account with read-only permission to the workbook.
- Configure player browser with persistent login.
- To fix filter values, append
&Filter=valueto the URL.
Metabase and Grafana setup
Metabase
Public dashboard with shareable URL:
Paste that URL in signage. Refresh: configure each dashboard panel with its own auto-refresh interval (5/10/30 min) or append ?refresh=300 to the URL for general 5-minute refresh.
Grafana
Kiosk mode for signage:
The kiosk=tv parameter hides all UI leaving only the charts. refresh=30s auto-refreshes every 30 seconds (configurable: 5m, 1h, etc.).
Want to show dashboards on your office or team room screen? Digisini supports URLs with auto-refresh on any plan.
Start free (no card)Designing dashboards specifically for TV
This is where 90% of BI-on-signage rollouts fail: copying a dashboard designed for 24' monitor and viewing it on 55' TV from 4 metres. Result: unreadable text, too many charts cluttering, colours that don't contrast at distance.
Rules for signage-friendly dashboards:
- Maximum 4-6 KPIs per screen. More becomes unreadable at distance.
- Large text: titles 40-60px, main values 80-120px, labels 24-32px.
- High contrast: ratio >7:1 between text and background. White text on dark background works better than the reverse.
- Few colours: 3 colours max (blue/grey for neutral, green for positive, red for negative).
- Absolute numbers over complex percentages: "127 leads today" reads at 4m. "+12.4% vs LW" doesn't.
- Target resolution: 1920×1080 (most TVs). For 4K, scale everything 2x.
For general design rules in signage (not BI specific), see 7 design principles.
Security and permissions
4 recommended security layers for BI on signage:
- Separate "internal" from "signage" dashboards. The signage dashboard is a clean version, no detailed personal data, only visible aggregates.
- Dedicated service account with read-only permissions to the specific workspace. Never use your personal account logged in on the player.
- Screen physically positioned where only the appropriate team can see it. Not in customer-facing reception if showing sensitive data.
- Compliance: if your company has GDPR, ISO 27001 or internal data policies, document what's shown where and why. SOC2 / ISO audits usually ask.
Most costly mistake observed: company publishes Power BI with "Publish to web" thinking it's only for internal signage, gets indexed by Google. Confidential data publicly accessible for months. Always prefer service account authentication over public URLs.
Refresh and performance
Aggressive refresh is the hidden cost trap in BI signage. Every dashboard refresh:
- Your data source (database, API, warehouse) receives queries.
- Your BI platform processes visualisations.
- Credits/queries consumed on freemium platforms or cloud BI costs.
| Refresh | Queries/day | Indicative BigQuery cost/month | When to use |
|---|---|---|---|
| 30 seconds | 2,880 | ~£120 | Only DevOps/IoT critical real-time |
| 5 minutes | 288 | ~£12 | Support tickets, operational metrics |
| 15 minutes | 96 | ~£4 | Sales, operational KPIs |
| 1 hour | 24 | ~£0.80 | Strategic, finance |
| 1 day | 1 | ~£0 | Executive dashboards, brand |
Rule: ask yourself "how much does this KPI actually change in X minutes?". If the value doesn't move in 15 minutes, refreshing every minute just burns money without value. For 95% of SMB cases, 10-15 minute refresh is the sweet spot between freshness and cost.
Common mistakes to avoid
The mistakes we see most when integrating BI into signage:
- Designing for monitor, showing on TV. Dashboard designed for 24' looks unreadable on 55' at 4m. Design specifically for signage or create a "TV-friendly" variant.
- Public "Publish to web" URL with sensitive data. Indexable, silent leak. Use service account.
- Refresh too aggressive (every 30s) saturating data source with no real benefit.
- Too many KPIs per screen. 10 charts on a TV = no one reads anything. Max 4-6.
- No fallback if dashboard fails. If the URL doesn't respond, the screen goes black. Configure a static alternative piece.
- Filters/controls visible to viewer. The dashboard has interactive controls the casual viewer sees and breaks. Fix values in the embed URL.
- Screen rotating dashboards too fast. 10 seconds isn't enough to read a KPI. Minimum 30-60s per dashboard.
- Not protecting service account. If the password leaks, workspace access. Use MFA if available + rotate credentials.
Want to show KPIs on team room screens? Digisini Pro plan supports URLs with auto-refresh and coordinated multi-screen.
Start free (upgrade to Pro when you need)