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

[RichCopenhagen]

Hi folks,

I am attempting to query our Salesforce instance to bring data into PowerBI Desktop Version 2.59.5135.601 64-bit (June 2018). Most object imports (opportunity, lead, account) are working fine, but when I attempt to bring in the Task object I get the following error at the Navigation step.

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

Details:
  List

I have not seen any other discussions about this particular error, but I'm hoping someone can point me in the right direction to resolve. I am unclear as to how I would reduce the incoming data prior to the Navigation step.

Automatically generated query appears as follows:

let
Source = Salesforce.Data(),
Task1 = Source{[Name="Task"]}[Data]
in
Task1

Thanks,

Rich

[Syndicate_Admin]

Hi, for me it worked to get Admin profile in Salesforce and the error dissapeared.

[Syndicate_Admin]

Hi, I'm getting this issue as well and also can't reach the links above. Anyone knows what to do?

[aylan]

Hello,

I'm facing the same problem, have you found any solution, please?

thank you

[v-yuezhe-msft · Accepted solution]

@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

[MostlySunny]

I realize this was 4 years ago, but do you have cliff notes on what the links you provided advise? It looks like the sites are no longer hosted.

[RichCopenhagen]

Thank you Lydia, this is immensely helpful. I am not in an admin profile, so I will pursue this to resolve.

Thanks,

Rich