Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Column Missing when importing Salesforce Data as an Object

Hello everyone,   I am importing data from Salesforce into Power BI. Right now I am connected to Salesforce Reports, but I would like to connect to Salesforce Objects to remove the 2000 row limit. ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Link,

     

    Thanks a lot. Checking off "include relationship columns" before connecting to Salesforce brought new columns and the opportunity owner is now included, that was a big relief!

metrica's avatar
metrica
Post Prodigy
3 months ago

Hi SDittmannFleet, your follow-up sat unanswered for a while, but the issue is a known one with the native connector. For wide tables (125+ columns), the Object connector starts hitting Salesforce's SOQL query length limit, especially when relationship columns are pulled in. Even with relationship columns unchecked, the default field list can still exceed the limit on large objects, and columns get silently truncated. The "Select Query" workaround Link mentioned solves it but requires writing SOQL manually, which isn't great for non-developers.

 

If you'd rather pick fields visually without writing SOQL, Power BI Connector for Salesforce on AppExchange has a UI for that - you see every available field (label + API name side-by-side) and check the ones you want before the data comes into Power BI. So wide objects don't truncate, and you don't end up missing essential columns like Opportunity Owner.

 

Free 30-day trial if you'd like to test it on the tables that were giving you trouble. Setup guides at https://metricasoftware.com/, and we're around for a demo if useful.

 

Cheers,

Metrica Team.