- Home
- Salesforce automation
- Salesforce reports and dashboards
Salesforce dashboards chart your reports, and the API refreshes up to 200 an hour
A Salesforce report is a set of records that meet your filters. A dashboard shows data from reports as charts, tables, metrics or gauges. We read Salesforce's own guides on 18 November 2026 for the limits that decide how far you can automate both, from 200 dashboard refreshes an hour to 2,000 rows per API call.
Reports and dashboards are two different records
A report holds the data, and a dashboard shows it. Salesforce’s Object Reference defines a report as “a set of data that meets certain criteria, displayed in an organized way”. It says a dashboard “shows data from custom reports as visual components”.
Each of those visual parts is a dashboard component. Salesforce says a component can be a chart, metric, table or gauge. Its CustomReportId field names the report that provides its data. So when a dashboard number looks wrong, the fix starts in the report behind it.
Reports come in four formats. The API uses one name, and the app shows another for the last one:
Scroll the table sideways to see every column.
| Format in the API | Label in the app | What the reporting API can do with it |
|---|---|---|
| Tabular | Tabular | Run it on demand or in the background |
| Summary | Summary | Run it on demand or in the background |
| Matrix | Matrix | Run it, and the only format for historical tracking reports |
| Multiblock | Joined | Not in the API’s list of formats it runs |
Salesforce’s reporting API runs tabular, summary or matrix reports. Joined reports are not on that list. The API’s report metadata can still name a joined report, as MULTI_BLOCK, from API version 43.0.
Three dashboard types decide whose data a viewer sees
A dashboard runs as a user, and that user’s access sets what it shows. Salesforce’s Object Reference lists three types:
- SpecifiedUser. Shows data at the access level of one named running user. Everyone who opens it sees the same numbers.
- LoggedInUser. Shows data at the access level of the person viewing it. Two reps can open it and see different deals.
- MyTeamUser. Works like LoggedInUser, and also lets managers view it as people below them in the role hierarchy.
Pick the type before you build the charts. If every viewer must see the same pipeline, use SpecifiedUser. If each rep should see only the deals they can open, use LoggedInUser.
Salesforce’s reporting limits, per hour and per call
The Reports and Dashboards REST API is the door software uses to run reports and refresh dashboards. Salesforce says it is part of standard Salesforce and needs no add-on or license. It works for any org with API access, through a session signed in with OAuth.
Its limits, from the developer guide for version 68.0, Winter ’27:
Scroll the table sideways to see every column.
| What you do | Limit Salesforce publishes |
|---|---|
| Run a report and wait for it | 500 runs per hour for the org, 20 at a time |
| Run a report in the background | 1,200 requests per hour; results kept for 24 hours |
| Read report rows | The first 2,000 rows per run |
| Report size | Up to 100 columns |
| Filters added at run time | Up to 20 custom field filters; cross filters, standard report filters and row-limit filters are not available |
| Refresh a dashboard | 200 refreshes per hour for the org |
| Read dashboard results | Up to 5,000 dashboards per hour |
| Subscribe to reports | Up to 5 per user |
Salesforce adds that every limit on reports and dashboards built in the app also applies to the API. Its Help page on those builder limits returned an empty page to our fetcher, so they are not listed here.
Plan these calls into your API budget too. Salesforce’s own sample Excel download returns the Sforce-Limit-Info header. Salesforce uses that header to report API usage on REST API responses, and it counts limits for the whole org, not per user.
How to automate Salesforce reports and dashboards
Salesforce gives three ways to put reports on a schedule or pull them out. Each has its own limit.
Subscriptions. A subscription sends results to people on a schedule. Salesforce’s API lists report subscriptions, dashboard subscriptions and Analytics notifications. Each can run daily, weekly or monthly. Each user can subscribe to up to 5 reports and create up to 5 Analytics notifications. Historical tracking reports cannot be subscribed to at all.
Export to Excel or JSON. The Reports REST API can run a report and download the result as JSON or Excel in one call. Salesforce warns that this endpoint is not built for exporting large formatted reports side by side. Run one large export at a time.
Dashboard refresh. A PUT request on the Dashboard Results resource starts a refresh. Salesforce says dynamic dashboards can be refreshed this way too. The org-wide cap is 200 refreshes an hour, so refresh on a schedule, not on every page view.
For long reports, run them in the background. Salesforce says the 2-minute overall API timeout does not apply to background runs. You fetch the result later, and it stays available for 24 hours.
What Salesforce’s own AI does for reporting
Salesforce calls Tableau Next “the next generation of our analytics portfolio”. It also calls it “a flexible, API-first analytics experience”. It says Tableau Next licenses are included in Core, Advanced and Max Editions for Sales, Service and Industry Clouds.
What it covers, in Salesforce’s words:
- Agents built in. Tableau Next works with Agentforce and comes with analytics skills from Tableau Agent.
- Alerts. It sends proactive alerts when metrics change.
- Older tools stay. CRM Analytics continues for customers not ready to move.
Saving dashboards and reports as images or PDFs is a separate tool. Salesforce’s Analytics Download API does it. It needs a CRM Analytics license, with Slack for Salesforce and CRM Analytics for Slack turned on. The reports API above needs no add-on.
AI tools outside Salesforce can reach Tableau Cloud too. Tableau Cloud is not the same product as Tableau Next: Salesforce sells Tableau Next on its own or with Tableau Cloud in the Tableau+ Bundle. Tableau’s official MCP server runs as a managed service at mcp.tableau.com, and each user signs in with their own Tableau Cloud login through OAuth 2.1. On its Claudeforce page, Salesforce listed its Tableau skills for Claude as coming soon. Our page on Salesforce MCP covers those servers.
Where a custom reporting agent fits
Salesforce’s own tools now answer questions too, through Tableau Agent skills in Tableau Next. A custom agent fits when the answer needs data from a system you have not connected to Salesforce, such as your ERP, or a rule only your company uses.
Our team has built Salesforce agents for six jobs, some in Agentforce and some as custom agents. Data analytics and reporting is one of them. A manager asks a question in plain words, such as which deals slipped this month. The agent finds the records and builds or refreshes the report behind the answer.
Our team has also done data work on Salesforce, including moving a company’s records in during an implementation.
A reporting agent has to live inside the limits above. A well-built one uses background runs for big reports, keeps refreshes well under 200 an hour, and signs in through an external client app with OAuth 2.0. Salesforce requires that kind of app, or a connected app, for any outside tool that calls its REST API. See Salesforce AI agents for the other five jobs. The first call is free.
Questions
What is the difference between reports and dashboards in Salesforce?
A report is the data. Salesforce defines it as a set of records that meet certain criteria, shown in an organized way. A dashboard is the picture. It shows data from reports as visual parts, and each part is a chart, metric, table or gauge. So every dashboard part reads from a report, and fixing a wrong number starts in the report.
What are the different types of dashboards in Salesforce?
Salesforce's Object Reference lists three. A SpecifiedUser dashboard shows data as one named running user sees it. A LoggedInUser dashboard shows data as the person looking at it sees it. A MyTeamUser dashboard does the same, and also lets managers view it as people below them in the role hierarchy. Pick by who should see which records.
Can a Salesforce dashboard refresh automatically?
Yes, through the API or a subscription. A PUT request on the Dashboard Results resource refreshes a dashboard, and your org can make up to 200 of these an hour. Dashboard subscriptions can run daily, weekly or monthly. Salesforce's Help site, where the in-app schedule settings are described, returned an empty page to our fetcher, so we cannot quote them.
How do I automate a Salesforce report export?
Two ways. A report subscription sends results on a schedule, and each user can subscribe to up to 5 reports. Or the Reports REST API can run a report and return it as JSON or Excel. Salesforce says to run only one large formatted export at a time. For long reports, run them asynchronously, because the 2-minute API timeout does not apply.
How many rows can the Salesforce reports API return?
Up to the first 2,000 report rows per run. Salesforce says to narrow the results with filters, and you can add up to 20 custom field filters when you run a report. The API also handles only reports with up to 100 columns. For bigger pulls, query the records directly. Salesforce calls any data job over 2,000 records a good candidate for Bulk API 2.0.
What is the main purpose of a dashboard?
To show report data at a glance. Salesforce says a dashboard shows data from custom reports as visual components, and each one is a chart, metric, table or gauge. Its type decides whose access it reflects: one named user, the person viewing it, or a manager looking down the role hierarchy. Through the API, your org can refresh up to 200 dashboards an hour.
Sources
Every source behind a figure or a vendor fact on this page, with the day we read it.
- Salesforce, Reports and Dashboards REST API Developer Guide, version 68.0 (PDF)Read 18 Nov 2026
- Salesforce, Object Reference (PDF)Read 18 Nov 2026
- Salesforce, Tableau NextRead 18 Nov 2026
- Salesforce, Bulk API 2.0 and Bulk API Developer Guide (PDF)Read 18 Nov 2026
- Salesforce, ClaudeforceRead 18 Nov 2026
- Tableau on GitHub, Tableau MCPRead 18 Nov 2026
- Salesforce, Platform limits cheat sheet (PDF)Read 18 Nov 2026
- Salesforce, REST API Developer Guide (PDF)Read 18 Nov 2026
- CadenceWorks, Salesforce AI agentsRead 18 Nov 2026
Bring the Salesforce reports your managers ask for
The first call is free. Bring the questions your managers ask each week and the reports that answer them today, and we can talk through what an agent could take on.