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
For those still wondering, the Salesforce.Data built-in connector in Power Query folds queries, so you can include a filter in your query, which allows you to at least see what columns etc. are available. You can refine the filter after.
Here is what worked for me:
let
Source = Salesforce.Data(
"https://login.salesforce.com/",
[
ApiVersion = 48,
CreateNavigationProperties=true
]
),
Table = Source{[Name="Task"]}[Data],
Filtered = Table.SelectRows(
Table,
each [CreatedDate] >= #datetime(2026, 6, 1, 0, 0, 0)
)
in
Filtered