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!

v-xulin-mstf's avatar
v-xulin-mstf
Community Support
5 years ago

Hi Anonymous

 

There's a limit on the number of fields a query to Salesforce can contain. The limit varies depending on the type of the columns, the number of computed columns, and so on.

Maybe this cause your issue, it means that your query exceeds the limit. To avoid this error, use the Select Query advanced option and specify fields that you really need.

For more information, you can refer:

https://docs.microsoft.com/en-us/power-query/connectors/salesforceobjects#known-issues-and-limitations

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

Anonymous's avatar
Anonymous
Not applicable
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!

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    Hi Anonymous,

     

    Is your issue solved?

    If the issue has been solved, please adopt the solution to help others.

    If you still have some question, please don't hesitate to let me known.‌‌

     

    Best Regards,

    Link

     

    Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!