Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Salesforce Data Tables for Relationship

Hello Everyone,   I am using Desktop Pro and pulling SalesForce Objects (not pulling all 382 tables, only Account, Agreement, Lead, Opportunity, and Transactions). What I am trying to find out is w...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous ,

    Based on your description, my understanding is that you want to find a table which lists the relationship between "ChildAccounts" and "Parent" from SalesForce Objects data source.

    Actually, this relationship has been contained in the table “Account”, please refer to the following steps: load data into PowerBi Query editor.

     

    Then find the column ChildAccounts and Parent, refer to the following picture to choose required columns and expand these data:



    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous ,

Based on your description, my understanding is that you want to find a table which lists the relationship between "ChildAccounts" and "Parent" from SalesForce Objects data source.

Actually, this relationship has been contained in the table “Account”, please refer to the following steps: load data into PowerBi Query editor.

 

Then find the column ChildAccounts and Parent, refer to the following picture to choose required columns and expand these data:



Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello Lydia,

 

I was able to update per your instructions and pull the data over. Thank you so much for the help! 

 

Sincerely,

 

Veejay