DataSource.Error: exceeded 100000 distinct who/what's

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