Total Rows Incorrect from Salesforce report
I have a data set that pulls from a Salesforce report with Accounts, Contracts, and Subscriptions. I'm using the FULL ID (18-digit) on the Subscription record as the unique ID to pull more than 2000 records from Salesforce.
When I refresh that data set, I get wildly varying records returned, sometimes over the number of records I see in Salesforce, sometimes under... by a couple thousand each time.
When I look at the data table for that data set in Domo, I do see duplicate IDs in the FULL ID column. I exported the same report from Salesforce and verified that there are no duplicates for that column in Excel.
Has anyone run into this before?
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 302 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board