Power BI/Salesforce Cross-object Reference Error - Cannot refresh data

[RevOps608]

Help,

I just received this error in Power BI. I'm unsure how to fix. I would delete some of the columns listed but i cant 'Choose Columns' because of the error. I'm unsure how to fix and although I've been able to find a few other data:source errors on here, not one like this. How can I fix this.

Opportunity

OLE DB or ODBC error: [DataSource.Error] You cannot add more than 15 different cross-object references per entity to a soql query. You added 17. Here are the fields and their cross-object reference counts: Tax Accountant from Account : 1 Disp Prop Cap Cost : 1 CPA Street : 1 CPA Email : 1 Tech Contact Email : 1 End Client Street : 1 Referral Source Origin : 1 OPPORTUNITY_REFERRAL_1_CONTACT_NAME : 1 Channel Referral CPA : 1 Referral 2 Contact Phone : 1 Account Manager - Sales Email : 1 LegalOrAccountName : 1 CPA City : 1 CPA Firm Billing State : 1 CPA Contact First Name : 1 Tech Director Phone : 1 Record Type Name : 1 Referral 1 Contact Email : 1 CPA Mobile Phone : 1 End Client Last Name : 1 OwnerID Email Primary : 1 OwnerID Email Secondary : 1 End Client Zip : 1 End Client Email : 1 ACV Variance : 1 Tech Director Email : 1 CPA Firm : 2 Referral 2 Contact Email : 1 First Opportunity Referred by Contact : 1 CPA Zip : 1 End Client Mobile : 1 CPA Firm Street : 1 Is First Won Opportunity : 1 Account Manager - Sales Name : 1 Channel Referral Firm : 1 End Client First Name : 1 CPA Phone : 1 CPA Firm Billing City : 1 End Client ID : 1 CPA State : 1 Contact CPA Only : 1 End Client Phone : 1 Special Terms : 1 Disp Prop Land Val : 1 End Client State : 1 Owner Number : 1 End Client City : 1 Referral 1 Contact Phone : 1 OPPORTUNITY_REFERRAL_2_CONTACT_NAME : 1 CPA Firm Billing Zip : 1 Parent Account Formula : 2 Referring Firm ID : 1 First Opportunity Referred : 1 OwnerID Last Name : 1 Pays 100% on Final : 1 CP: Staging : 2 Tech Contact Mobile : 1 OwnerID First Name : 1.

[amitchandak · Accepted solution]

@RevOps608 , How many Merge/Append have you used, if more than 15? Seem like that is causing issue

[RevOps608]

I spoke to our Salesforce Consultant and this is a Salesforce issue. Our org has too many cross object references, not power bi. Really confusing error. I'll close this out. Thanks for replying.