Query is either selecting too many fields Error

[Charles]

I'm using the Salesforce Object Connector, but receive the following error message when loading the data:

DataSource.Error: Query is either selecting too many fields or the filter conditions are too complicated.
Details:
List

I won't need all columns from the object so I want to reduce the number of columns selected.  I understand how to do this once the connection is established, but given the above error I dont have the option.  The Choose Coulmns button is grayed out.

Any ideas?

[v-yuezhe-msft · Accepted solution]

Hi @Charles,

In Query Editor of Power BI Desktop, please open Advanced Editor of your current query, then reduce columns in the code within Advanced Editor. There is an example for your reference.




Thanks,
Lydia Zhang