If the data displayed on your Salesforce widget differs from what's in your report, it might be due to over 2,000 rows of data in your Salesforce report. Salesforce's API is limited to fetching a maximum of 2,000 data records. Exceeding this limit means some data may not be retrieved.
You can hide the "detail rows" in the report to circumvent this issue. This adjustment ensures that only the final results are fetched, avoiding the 2,000-row limit.
How to hide detail rows in your Salesforce report
Edit your Salesforce report.
At the bottom of the report, switch the "Detail Rows" toggle to OFF.
Save and run the report.
You can now edit your Salesforce widget and reload your report by clicking the downward arrow beside the report name in the config.
