Forum Discussion

Charles's avatar
Charles
Regular Visitor
9 years ago
Solved

Query is either selecting too many fields Error

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

metrica's avatar
metrica
Post Prodigy
12 days ago

Hi Charles,

 

This error means the Salesforce query exceeds the field or query-complexity limit. In the current Salesforce Objects connector, use the Select Query option to request only the required fields.

 

Power BI Connector for Salesforce also provides visual field selection, filters, SOQL, and data preview.

 

AppExchange and 30-day trial:

https://appexchange.salesforce.com/appxListingDetail?listingId=31526f0e-abd8-4cb5-bd1a-3bd56b5c0577

 

Docs and support:
https://metricasoftware.com/docs/salesforce/
https://metricasoftware.com/docs/salesforce/contact-support/

 

Cheers,
Metrica Team