TABLEAU QUESTIONS

Does Tableau Auto Refresh Also Refresh the Data and Send Reports?

The warehouse screen reloads every few minutes, but the morning PDF still shows items dispatched yesterday. The display looks current while the figures tell a different story.

Advanced Tableau Report Scheduler (ATRS) can bring a supported Tableau Cloud extract refresh, report preparation and delivery into one workflow, helping the team receive the stock figures it needs.

  
THE PROBLEM AND ANSWER

Why the screen can look fresh while the figures are old

The warehouse team keeps a stock dashboard on a wallboard. The browser reloads it regularly, so everyone assumes the figures are up to date. Then the manager opens the morning PDF and spots items that were dispatched yesterday.

Start with the data behind the view. A Tableau extract is a stored copy of data. The order system may have recorded those dispatches while the extract still holds the previous day’s stock. Asking the view to query that extract again cannot add records the extract has not received.

A live connection follows a different path: it queries the source instead of relying on that stored extract. Even then, cached query results can affect what the team sees. Tableau’s view refresh retrieves updated information from the configured source; the source itself still needs to contain the completed warehouse update.

The morning PDF is another part of the routine. It needs a process to generate and deliver it after the right data is available. ATRS can manage that file preparation and delivery, including a supported extract refresh beforehand when the workflow requires one.

A teal monitor, separate database cylinder and report envelope illustrate distinct viewing, data and delivery tasks.

The source data, the dashboard view and the delivered file each have a part to play in keeping the team informed.

Pick an item the warehouse knows

An item dispatched yesterday gives you a useful thread to follow from the stock system to the dashboard and morning PDF.

  
YOUR OPTIONS

Choose how the data and report should update

For a wallboard that needs to display current figures, start with Tableau’s connection and refresh settings. Check that the source contains the new stock movements and, for an extract, that its refresh completed. Then check the report’s date and filters. A current source viewed for yesterday’s period can look like a failed refresh.

For the manager’s regular image or PDF, a native Tableau subscription may be enough. Where eligible, When Data Refreshes can send the snapshot after a scheduled extract refresh. That provides a useful native route when its format and refresh requirements fit.

ATRS adds value when the handoff needs more coordination. The manager might need a PDF by email, the warehouse analyst might need an Excel file, and a shared folder might need another copy. ATRS can maintain the report inputs, outputs and destinations along with the tasks that prepare the report.

It can also respond to a configured database or file condition when a warehouse load finishes at different times each day. Define what that signal means for this report: the file arriving or the load record appearing should represent the completed stock period the manager expects.

View refresh, extracts and native subscriptions

Tableau’s view refresh clears cached results and retrieves information from the configured data source. An extract refresh updates the stored extract using its supported full or incremental refresh configuration. A browser reload does not substitute for that extract update.

For live-connection workbooks, data freshness policies control reuse of cached query results. These policies do not apply to extract or file-based data sources. Choose freshness settings with the workbook owner, taking query performance into account.

Tableau’s When Data Refreshes subscription option is available for eligible workbooks using one extract on a published connection. Refresh-initiated subscription emails are not supported for Bridge-refreshed sources. Save a Custom View when the subscription needs particular filters. See the Tableau subscription guide.

Desktop’s automatic-update controls concern queries while an author changes a view. They do not create an unattended extract-refresh or email schedule.

The screen and the file serve different moments

The wallboard helps people during the shift. The manager’s PDF supports the morning review. Both need the right stock update behind them.

  
SET IT UP

Prepare the morning report after the data is ready

Build the ATRS job around the stock report the manager already uses. Select the Tableau account and report, set the supported business-date input, and choose the output and a test destination. Check that the selected period matches the completed warehouse load.

When ATRS needs to request a supported extract refresh, add the Refresh Tableau Datasource custom task before report generation. Choose the workbook or datasource, account and Item Path, then configure how long to wait for completion. Keep that refresh in the workflow that actually produces the file.

Run a controlled test after a known stock update. Open the received PDF and find the dispatched item from the warehouse system. Check the close date and total with the manager. The received file is the practical test of whether the whole handoff worked.

Then test what happens when the readiness signal is missing or the refresh fails or takes too long. Confirm the error response and whether delivery proceeds. Once those outcomes match the team’s reporting rules, enable the recurring workflow.

Refresh task settings and readiness checks

The ATRS General Custom Tasks guide documents Refresh Tableau Datasource, including Workbooks or Datasources, the account, Item Path and Wait for refresh completion up to setting.

A wait limit is not, by itself, proof that a failed or overdue refresh blocks delivery. Verify the error handling and downstream behavior in the installed workflow. The Tableau connection and source credentials still need to work.

Use an event-based schedule when report production depends on a configured file or database condition. In that route, keep required custom tasks before the report schedules. Check that a separate timed run cannot produce the report before the readiness condition is satisfied.

The export account needs access to the Tableau content, and the ATRS service identity needs access to the condition source and delivery location. Test the unattended run as well as a manual execution.

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

ATRS provides a Refresh Tableau Datasource task with account, Item Path and completion-wait controls.

Plan for a late update

Agree who tells the manager when the stock close is delayed. That gives the team an answer on the morning when the usual file cannot arrive.

  
FOR DEVELOPERS

Let your application request the morning report

The warehouse application may already know when the stock close is complete. It can request a tested ATRS report job at that point, leaving ATRS to prepare the PDF or workbook and deliver it.

Use the stock-close result as the reason to run the job. The wallboard’s page-load time only tells you about the display; it does not establish that the warehouse load has finished.

API example: execute the configured reporting job

This example runs an existing ordinary single-report schedule. Configure and test its report, business-date input, output and destination first, then replace 101 with its actual UniqueId.

Ensure any required refresh task belongs to the invoked job. Directly executing a report does not automatically run the conditions or tasks of a separate event-based schedule that would normally call it.

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>

Keep the returned ExecutionId with the requested stock-close date. Monitor the run and parse the JSON-encoded ResultJson; Completed can contain a failed result. Verify the file and destination using the ATRS execution guide.

Keep tokens on the backend. If the response is lost, investigate the existing run before submitting another request. The first run may already have produced a file or email.

Leave the stock date with the request

Someone investigating Wednesday’s PDF should be able to find Wednesday’s reporting run without reconstructing the wallboard’s history.

  
YOUR NEXT STEP

Give the manager the right stock figures

The wallboard and the morning report serve the same team in different ways. Keep the dashboard querying the right data, and give the delivered file a workflow that uses the completed stock period.

Start with one stock report and one known update. Explore how ATRS can coordinate the required refresh, report preparation and delivery so the manager receives figures the team can use.

Explore ATRS refresh and report delivery

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software