Forum Discussion
DataSource.Error: exceeded 100000 distinct who/what's
RichCopenhagen,
Do you have admin permission for Salesforce? It seems that you hit the limitation of Salesforce without being a admin user, please review the following similar threads about this issue.
https://getsatisfaction.com/dbamp/topics/salesforce_refresh_error_on_task_object
https://getsatisfaction.com/dbamp/topics/salesforce_account_permissions_required
Regards,
Lydia
Post ProdigyHi RichCopenhagen,
That "exceeded 100000 distinct who/what's" error is a Salesforce governor limit specific to Task and Event objects - both have polymorphic WhoId/WhatId fields, and Salesforce blocks the query when those references exceed 100K distinct values. Admin permission doesn't help here - it's an API limit, not a security one. The fix is to apply a filter before the query hits Salesforce - via Salesforce.Data Advanced Option → Select Query with hand-written SOQL (e.g. WHERE LastModifiedDate >= LAST_N_DAYS:30).
If you'd rather not write SOQL by hand, Power BI Connector for Salesforce on AppExchange handles filtering through a UI inside Salesforce:
Why it might fit:
- Filter conditions set on the Salesforce side - no SOQL hand-writing, no 100K distinct error
- No 2,000-row limit on reports
- Supports custom fields, custom objects, and joined reports
- 30-day free trial
- Setup docs: https://metricasoftware.com/docs/salesforce/
- Responsive support if you get stuck: https://metricasoftware.com/docs/salesforce/contact-support/
Happy to set up a quick demo on the Task object specifically. Just reach out via the support link.
Cheers,
Metrica Team.