Schedule a Demo
Schedule a Demo
Book a Demo
TABLEAU QUESTIONS

Why Is Download Data or Crosstab Unavailable in Tableau?

The warehouse manager can see the stock figures in Tableau, but the Excel download is unavailable just before the morning review. An administrator can export it, which only makes the problem more confusing.

Advanced Tableau Report Scheduler (ATRS) can handle the recurring Tableau Cloud workbook once the right source access is established, so the manager no longer has to download it each morning.

THE PROBLEM AND ANSWER Find what is stopping the stock-summary download
  
THE PROBLEM AND ANSWER

Find what is stopping the stock-summary download

Your manager asks for the stock summary in Excel. The dashboard opens normally, but Data or Crosstab is greyed out. The figures are there, and the review is about to start.

Begin with the table the manager needs and the account they actually use. Selecting the stock worksheet can resolve a selection problem; the content owner can then investigate the relevant download permission if the choice is still unavailable.

That explains why an administrator’s successful export is useful evidence but not the end of the conversation. The manager needs the intended stock summary under the access arrangements for their work.

Once that download works, you have a file to discuss with the warehouse. If it is the same summary every morning, ATRS can prepare and deliver it instead of making the manager repeat the download.

A locked report and magnified permission card illustrate diagnosing authorized access to report downloads.

Check the selected sheet and affected account to identify which part of the download needs attention.

Name the file the manager needs

A stock summary for one warehouse and business date gives the content owner a much clearer request than enabling every download.

  
YOUR OPTIONS

Get the right export working for the right person

Ask which columns the review depends on. Item totals may be enough for planning the shift, while individual stock movements serve a different investigation. That distinction helps the owner provide the export the manager needs.

A working native download may complete an occasional request. For the daily review, ATRS can keep the warehouse selection, business date and Excel preparation in a reporting job.

The file can arrive with a recognizable tab name and the formats the manager uses. A related report can join it in a package, while another destination keeps the team’s archive. Those additions save time after the access issue has been resolved.

Summary data, full data and effective permissions

Download Summary Data covers the aggregated data in a view or selected marks. Download Full Data covers the underlying data. These are separate from image/PDF and workbook-download capabilities. See Tableau’s capability reference.

A user’s site role sets the maximum capabilities they can receive. A Viewer can be allowed summary-data downloads but cannot be granted Download Full Data. A request for an Excel summary should therefore be distinguished from a request for underlying transactions.

Check effective permissions for the affected user on the relevant content. User rules, group membership and the site role can affect the result; one Allow setting may not tell the whole story.

If the dashboard is embedded in a portal, compare the same view directly in Tableau Cloud using the same account. A hidden toolbar concerns how the view is presented, while content permissions still govern the available actions. The download guide explains the sheet and format choices.

Talk through the review

The manager can show you which quantities drive the shift’s decisions. Use that to choose the useful level of detail.

  
SET IT UP

Have ATRS prepare the morning workbook

Use the manager’s working stock summary as the starting point. In ATRS, select the linked Tableau Cloud reporting account and report, then supply the warehouse and business-date values supported by that report.

Add the manager’s email or reporting folder and choose Excel output. If the review uses a familiar template, configure Excel Data Only so the stock table arrives in that layout.

Open a test delivery with the warehouse manager. Find an item they know, compare its quantity and discuss whether the workbook has what the review needs. This connects the scheduled account’s export with the file the manager was trying to obtain.

Then choose the morning recurrence around the completed stock update. The review can begin with the workbook waiting, while the reporting owner maintains the source and delivery.

ATRS Add a Tableau Account dialog with Token PAT selected and blank account connection fields.

Link the Tableau Cloud reporting account in ATRS, then test the selected report. This screenshot shows an older connection-dialog example.

Account setup, Excel options and unattended access

The ATRS account guide explains how to link a Tableau Cloud account. ATRS supports Tableau Cloud. Use a supported authentication method and API version for the installation; the pictured dialog is an older example.

The reporting account needs access to the selected content and required export. Its row-level restrictions apply to the resulting file. An email destination does not cause Tableau to generate the report as that recipient.

The Single Schedule guide covers report inputs, timing and destinations. The Excel export guide covers XLSX modes, worksheet naming, passwords, templates, totals and formatting.

For several outputs, use the package’s Excel merge option and inspect the completed workbook. Check the current host and Office prerequisites, along with the service identity’s access to templates and destinations.

Give the manager a first copy

Open the received workbook together and find a familiar item. It establishes what tomorrow’s scheduled file should look like.

  
FOR DEVELOPERS

Request the tested stock-summary job

The warehouse application may offer the manager another copy before an extra stock review. It can request the saved ATRS job, reusing its report, Excel preparation and destination.

The application authorizes the request and follows the result. The linked Tableau account continues to supply the report access used by the job.

API example: execute and monitor the stock-summary schedule

Replace 101 with the UniqueId of an existing tested single-report schedule. Its warehouse, period, Excel output and destination must already be configured. This execution request runs those settings; it does not change Tableau permissions.

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 and parse the JSON-encoded ResultJson when monitoring the run. Completed can contain a failed result. Confirm the file and destination using the ATRS execution guide.

Keep tokens on the backend. If the request outcome is uncertain, check the existing execution and delivery before submitting another run and producing a duplicate copy.

Make an extra review easy

The application can request the maintained stock-summary job when the manager needs another copy.

  
YOUR NEXT STEP

Give the manager a usable stock workbook

The manager began with a greyed-out download and an approaching review. Resolving the relevant selection or access issue gives them today’s summary; a recurring ATRS job can remove the same obstacle from tomorrow’s routine.

Use the warehouse’s working file to explore how the Excel preparation and delivery should fit the morning shift.

Explore ATRS Excel report preparation

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software