Forum Discussion

Nexans's avatar
Nexans
Frequent Visitor
5 years ago

Salesforce Object Connector - Nested query

Hi. I have a problem receiving the data that I want from the object connector. Through the Salesforce database our developer is able to query the data using a "nested query": In Power BI I ha...
Need Help
metrica's avatar
metrica
Post Prodigy
3 months ago

Hi everyone,

 

For anyone landing here with a similar nested SOQL question - Power BI's native Salesforce Objects connector doesn't translate nested subqueries the same way the Salesforce SOQL engine does. When you enable CreateNavigationProperties=true and use Table.ExpandTableColumn, Power Query does an N+1 expansion (one HTTP request per parent record) rather than a single Salesforce-side subquery. That's why behavior differs from your developer's direct SOQL.

 

For complex parent-child pulls like this, the cleanest path is usually to build a joined report on the Salesforce side (combining the parent object + child object via a Report Type) and pull that flat report into Power BI. Metrica Power BI Connector for Salesforce on AppExchange handles that path well - pulls joined reports without the 2,000-row cap, so you get parent + child data in one flat dataset without M-side expansion.

 

Free 30-day trial if you'd like to test it on the ClassMembership__Feed scenario. Setup guides at https://metricasoftware.com/, demo available on request.

 

Cheers,

Metrica Team.