All templates

Automated Power BI Report Distribution

Every morning, WebRun opens Power BI, reads the report page you nominate, captures the headline figures and how they moved, writes them into a shared Google Sheet anyone can open without a licence, and pins the same numbers to your leadership slot in Google Calendar.

Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 Power BI read the key report page
2 Google Sheets publish the figures to the team
3 Google Calendar pin them to the leadership slot
In short

How do I share Power BI numbers with people who have no licence?

Every morning WebRun opens Power BI, reads the key page of the report you nominate, and records the headline figures with the period and refresh time. It writes each day's numbers into a shared Google Sheet anyone can open without a licence and pins the same figures to your leadership slot in Google Calendar.

  • Executives get current figures without opening Power BI
  • Nobody waits on an analyst to screenshot a dashboard
  • Every snapshot carries the refresh time so stale data is obvious

Built for analysts · leadership teams · operations managers · finance

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens app.powerbi.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Power BI - read the key report page
    powerbi.microsoft.com
    WebRun in Power BI: read the key report page
    WebRun opens Power BI to read the key report page.
    • Open Power BI and go to the workspace and report you nominated
    • Load the key report page and wait for the visuals to finish rendering
    • Capture the headline figures, the period they cover, and the last refresh time

    Done when Today's headline figures are captured with their refresh time.

  3. 2
    Google Sheets - publish the figures to the team
    google.com
    WebRun in Google Sheets: publish the figures to the team
    WebRun opens Google Sheets to publish the figures to the team.
    • Open the shared snapshot sheet and add today's row
    • Write each headline figure, the period, the refresh time, and the change against yesterday
    • Leave the sheet shared read-only so people without a Power BI licence can still see it

    Done when Today's figures are in the shared sheet with yesterday's comparison.

  4. 3
    Google Calendar - pin them to the leadership slot
    calendar.google.com
    WebRun in Google Calendar: pin them to the leadership slot
    WebRun opens Google Calendar to pin them to the leadership slot.
    • Put the day's headline figures on your own morning leadership slot
    • Add the link to the shared sheet so anyone can open the detail
    • Never email the report out or invite anyone new. WebRun updates your own calendar only

    Done when The morning slot carries today's numbers and the sheet link.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.powerbi.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Daily figures · Google Sheets
OutputWhat each run produces - A daily row of the report's headline figures with the period covered, the last refresh time, and the change on yesterday.
Text
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it email the report to the leadership team?

No. WebRun writes the figures into a sheet you already share and updates your own calendar slot. It never emails a report out, so who can see the numbers stays controlled by your sheet's sharing settings.

Do the recipients need a Power BI licence?

No. That is the point of this run. The figures land in a shared Google Sheet, so anyone with access to the sheet reads the current numbers without opening Power BI or holding a licence.

What if the data has not refreshed yet?

WebRun records the last refresh time alongside every figure and says so in the row, so nobody mistakes yesterday's data for today's if a refresh has not landed.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.