How Do You Burst Tableau Reports for Different Customers or Locations?
Sending the weekly report is manageable with two locations. As more managers ask for their own version, filtering, exporting and addressing files begins to take over your morning.
Advanced Tableau Report Scheduler (ATRS) can use maintained reporting assignments to prepare and deliver each location’s Tableau Cloud report.
- THE PROBLEM AND ANSWER Turn one useful report into each location’s version
- YOUR OPTIONS Choose saved views or a maintained distribution list
- SET IT UP Prepare two location reports before extending the list
- FOR DEVELOPERS Let your portal request an approved location report
- YOUR NEXT STEP Give managers their figures without rebuilding every email
Turn one useful report into each location’s version
Imagine the sales coordinator preparing the weekly update for a growing group of stores. Each manager wants their own sales, with the completed week selected. The coordinator repeats the same export, changes the filename and chooses the next address.
Report bursting makes that repeated selection and delivery into a maintained reporting job. One reusable Tableau report can supply the different versions, while ATRS reads the store and delivery instructions from a database table or query.
That is useful for customers as well as locations. The instruction for each output can identify the approved report values, person, format and destination. The goal is a manager opening their own figures, rather than the coordinator working through another morning of attachments.
Begin with the assignment that connects a location to its reader. A recipient’s address routes a file; it does not by itself filter the Tableau data.
Each report’s store selection and delivery details stay together, even when every version starts from the same published report.
Keep the assignment together
The store value and its recipient belong to the same reporting instruction. Review both when a manager changes roles.
Choose saved views or a maintained distribution list
For a few stable management snapshots, Tableau Custom Views and native subscriptions may be enough. Save the intended store selections and maintain the appropriate subscription audience.
The work grows when managers move, stores open or finance asks for a different output. ATRS data-driven schedules can read those changing reporting assignments when the job runs, rather than require a separate manual export for each request.
One manager might receive a PDF by email while a local analyst needs an Excel workbook in a reporting folder. The useful choice follows what each person does with the figures, and the maintained record keeps that choice beside their store.
Data selection, driver records and supported personalization
The ATRS Data-Driven Schedule guide documents database-driven parameters, destinations and output formats. Use a unique Key Column and map the actual supported report parameter names and types. The report must use those values to select the intended records.
Inserts can place available values into supported naming, message and reporting fields. Maintain the customer/location scope, recipient, period and output instructions together. Inspect the returned driver records before expanding delivery.
ATRS connects to Tableau Cloud only and uses a configured Tableau account with the required source access. An exported file carries the data selected during production; a mailing-list change does not recall a file already delivered.
Give each format a job
A PDF can support the manager’s review while a workbook gives finance the cells it reconciles.
Prepare two location reports before extending the list
Choose two managers whose store totals you recognize. Agree the weekly report, store values, test destinations and filenames with the person maintaining those assignments.
Create the ATRS Data-Driven Schedule and connect its driver to the maintained query. Select the Key Column, Tableau Cloud account and report, then map each record’s store and reporting period to the supported inputs.
Map the destination and naming fields so the two versions remain recognizable. If a reader needs a prepared workbook, include the useful tab name, template and number formats in that output instead of leaving finance to repeat the finishing work.
Open both received files with the reporting owner. Compare each store, period and known total, and verify that the destinations match the assignments. Change one test assignment and confirm how the next selection follows it before enabling the wider weekly list.
The Data Driver defines the reporting records used by ATRS. Use your maintained store and delivery instructions in place of the pictured sample query.
Formats, packages and ongoing audience changes
Excel and Excel Data Only serve different preparation needs. Data Only offers template placement, selected totals, reusable styles and typed column formats; test the finished workbook rather than assume an image of the dashboard supplies usable cells.
When one reader needs several reports, use the Data-Driven Package workflow rather than duplicate this single-version pattern. Review queued or already-generated work separately when an assignment changes.
Follow two familiar totals
The received files should tell two distinct store stories before the list is expanded.
Let your portal request an approved location report
A store portal may let a manager request another copy before a review. Its backend can select the approved ATRS job while the reporting team maintains the report inputs and destination.
For a small setup, a tested single-report schedule for each store makes that choice explicit. Broader data-driven jobs need their own deliberate execution scope.
API example: request one approved store report
Replace 101 with the UniqueId of the tested single-report job for this store. The backend authorizes the manager before selecting the job.
POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json
{
"ScheduleType": "report",
"UniqueId": 101,
"RunBy": "Store portal request"
}
GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>This example does not filter a shared data-driven batch to one record. Running a whole batch may deliver every selected record; configure the intended scope instead of inventing a row or recipient override.
Follow the ATRS execution guide. Keep the token on an authorized backend. Monitor within a defined deadline and decode ResultJson; Completed can contain Result=false. Check the expected files and destinations before reporting delivery. Reconcile an uncertain execution before submitting another copy.
Authorize the portal request
A manager’s request should resolve to the location report they are allowed to receive.
Give managers their figures without rebuilding every email
The next weekly review can start with each manager’s own sales file. The coordinator can help explain the results instead of selecting another store and rebuilding another email.
Start with two recognizable locations and their reporting assignments. Use that pair to explore how ATRS can extend the same useful report across the audience.
Contributors:
Christian Ofori-Boateng
CEO, ChristianSteven Software

