TABLEAU QUESTIONS

How Do You Schedule Tableau Data and Extract Refreshes?

The warehouse database updated overnight, but the report waiting for the morning shift still shows the previous stock close. Moving another timer will not explain where the update was missed.

Advanced Tableau Report Scheduler (ATRS) can bring a supported Tableau Cloud refresh, report preparation and delivery into the same morning workflow.

  
THE PROBLEM AND ANSWER

Bring the overnight stock update into the morning report

Your warehouse manager expects yesterday’s final movements in the morning report. The stock system has them, but the PDF does not. Before changing the email time, follow the extract the report actually uses.

Tableau’s extract is its stored copy of the source data. Its refresh needs to pick up the completed warehouse load before the report is prepared. Refreshing an unrelated workbook or running before the load finishes will not give the manager that close.

A native refresh schedule may be enough when the source update finishes reliably and keeping the extract current completes the job. The available route depends on whether Tableau Cloud can reach the data directly or needs Bridge.

ATRS helps when the routine also includes producing the warehouse PDF, preparing finance’s workbook and delivering both. The refresh becomes part of the work that gets the morning figures into readers’ hands.

Tableau Server dialog for selecting an extract refresh schedule and refresh type.

Tableau Server’s scheduling dialog illustrates selecting the refresh schedule and type; Cloud’s scheduling controls differ.

Follow one stock movement

Choose a movement recorded near the end of the close. It gives the warehouse and reporting owner a useful thread through the update.

  
YOUR OPTIONS

Choose a refresh that follows useful new data

Begin with the person responsible for the overnight load. Ask when the stock close is complete and how the reporting process can recognize it.

A predictable finish may fit a native schedule. When the load varies, an ATRS file or database condition can start the reporting workflow after the relevant completion signal appears.

Then decide who updates the extract. ATRS can request a supported refresh; a Bridge-owned update needs its own supported completion path. Agreeing that responsibility gives the manager a more useful routine than another guess at how many minutes to leave between timers.

Native scheduling, Bridge and refresh-triggered subscriptions

Tableau Cloud. Refresh schedules offer hourly, daily, weekly and monthly frequency families. Full refresh is the default; incremental must be configured before publishing. Selecting full-only content can disable the incremental choice. Cloud also documents a two-hour refresh timeout. Review the applicable path and error before applying that limit to a Bridge job. See Cloud scheduling.

Private-network data. Bridge schedules rely on the clients, pools and source access maintained for the site. After publishing, the data source’s Extract Refreshes tab provides controls to add a refresh or change its frequency. Confirm the connection and credentials work unattended. See private-network refresh scheduling.

Tableau Server. Administrators create schedules on the Schedules page. Select the published content under Explore, choose Actions > Refresh Extracts, then the available schedule and refresh type. See Server scheduling. These native Server instructions are separate from ATRS, which supports Tableau Cloud only.

Native email after refresh. An eligible published-extract connection can support When Data Refreshes subscriptions. Bridge refreshes, live connections and multiple extracts have restrictions. If a mixed-source workbook offers the option, the triggering extract refresh does not establish that its Bridge update completed. See subscription troubleshooting.

Ask what complete means

The source owner can explain which load finishes the stock day. That conversation helps you choose the reporting start point.

  
SET IT UP

Put refresh, report preparation and delivery together

Start with the stock report and your own test destination. Select its Tableau Cloud account and close-date inputs in ATRS, and prepare the file the warehouse uses.

When ATRS is to request the supported extract update, add Refresh Tableau Datasource before report production. Choose the intended workbook or datasource and configure its completion wait.

If a warehouse-load signal starts the process, arrange the event workflow so the required refresh work comes before the report. Keep the independent timed send from getting ahead of that workflow.

Run it after a known close and open the received report with the warehouse. Find a movement the manager expected, then try the delayed or failed update and agree how the team will hear about it. Include finance’s workbook and archive copy where they are part of the same morning handoff.

Orange ATRS Refresh Datasource Extract task with account, target and completion-wait controls.

Select the actual extract target and its completion wait when configuring the refresh task.

Completion waits, event conditions and delivery checks

The General Custom Tasks guide documents the refresh target and completion wait. A separate Wait/Pause adds elapsed time; that alone is not evidence that a refresh succeeded. Verify the failure and timeout behavior of the installed sequence rather than treating the wait value as an automatic stop rule.

The Event-Based Schedule guide describes file and database conditions and starting an existing schedule. Use ALL when every selected condition must hold. Define the period and completion evidence, and test repeat polling so one completed load does not generate unwanted repeat deliveries.

For Bridge-managed updates, verify the actual supported refresh and completion path. The presence of an ATRS refresh task does not establish a universal Bridge completion hook. If an external process owns the update, supply readiness evidence that covers the required extract and period.

The Tableau account needs access to the selected content and requested operations. The ATRS service needs access to condition sources, templates and destinations. Use the Single Schedule guide for report setup, and the Excel guide for workbook preparation. Check the actual attachment or saved file, including any merge, protection or template.

Plan the difficult morning

Agree who tells the warehouse when current figures are unavailable. Include that response while you try the workflow.

  
FOR DEVELOPERS

Let your application request the tested reporting job

The warehouse application may already know when its nightly work is complete. It can request the prepared ATRS reporting job at that point.

The reporting team maintains the required refresh, outputs and destinations in the chosen workflow. The application keeps the close date with the requested run so a colleague can follow it later.

API example: request and monitor the configured report

Use your ATRS HTTPS address and a backend-held bearer token. This example runs an ordinary single-report schedule. Replace 101 with its actual UniqueId. Configure its report, supported refresh tasks, output and destinations beforehand and test success, failure and timeout behavior.

POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json

{
  "ScheduleType": "report",
  "UniqueId": 101,
  "RunBy": "Warehouse application"
}

GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>

Retain the returned ExecutionId. Poll status within a defined time limit and parse the JSON-encoded ResultJson; Completed can contain Result=false. Inspect errors and verify the file’s period and destination before confirming readiness.

Executing a report directly does not run a separate event parent’s conditions or tasks. If the readiness check or refresh lives there, this direct request is not a substitute. Use the documented execution route for the tested job and its actual schedule type.

The request runs saved reporting settings. It does not define custom tasks in the payload or create a native Tableau refresh schedule, and its execution ID is not a Tableau refresh-job identifier. Native refresh administration follows Tableau’s supported configuration.

After an uncertain response, reconcile the earlier execution and destination before submitting another run to avoid duplicate reports. See the ATRS execution and monitoring guide.

Leave the close date with the run

A colleague should be able to find the reporting execution for a particular morning without reconstructing every timer.

  
YOUR NEXT STEP

Have the current stock figures ready for the team

The morning report can now follow the completed stock period the warehouse is waiting for. When an update is late, the team has an agreed response rather than another unexplained old report.

Start with one source and one morning file. Use them to decide whether native scheduling is enough or whether ATRS should bring the refresh and delivery together.

Explore ATRS refresh and delivery

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software