cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cdfisher89 Regular Visitor
Regular Visitor

Query Salesforce Data Error - Query too complicated

I am getting the below error when I query our opportunity (assignment) data from Salesforce.  How do I simplify the query?  Do I have to pull-in less fields?

 

2016_08_22_12_29_51_Assignment_Query_Editor.png

5 REPLIES 5
cdfisher89 Regular Visitor
Regular Visitor

Re: Query Salesforce Data Error - Query too complicated

I am also getting this errror for a custom object.2016_08_22_12_36_55_Assignment_Power_BI_Desktop.png

cdfisher89 Regular Visitor
Regular Visitor

Re: Query Salesforce Data Error - Query too complicated

Help! Still having this issue!

cdfisher89 Regular Visitor
Regular Visitor

Re: Query Salesforce Data Error - Query too complicated

I solved it.  I just needed to go into the advanced query editor and reduce the number of fields

Highlighted
Charles Frequent Visitor
Frequent Visitor

Re: Query Salesforce Data Error - Query too complicated

I'm having the same issue, but cannot work out how to edit the query to reduce the columns.

 

How can the columns be selected prior to the creating the connection?

cdfisher89 Regular Visitor
Regular Visitor

Re: Query Salesforce Data Error - Query too complicated

You need to Click on Edit in when you are loading the object - see image.  You then go into advanced Query editor and specify what columns you want.  Sorry for the late respocnc2017_05_16_11_16_42_SAAMv2_Power_BI_Desktop.png

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors