+ Start a Discussion
Stijn VermeulenStijn Vermeulen 

powerbi accountcontactrelation

We are trying to connect to SalesForce objects via PowerBI Desktop, but the object "Account Contact Relationship" is not shown. How can we make it visible? The user has access to this relationship in Salesforce.
VinayVinay (Salesforce Developers) 
Do you have this object associated single contact record to multiple account records?

https://www.salesforceben.com/the-drip/salesforce-account-contact-relationship-fields-relate-a-contact-to-multiple-accounts/

Thanks,
Stijn VermeulenStijn Vermeulen
Hi Vinay,

Yes, we have the single contact to multiple accounts functionality enabled.
It is showing up in the Salesforce UI, but when trying to extract the data to excel using PowerBI, the object is not available.

Thanks for looking in to it!
Mosh HamedaniMosh Hamedani
Our web scraping services (http://it-s.com/our-services/data-tranformation-services/web-scraping-services/) provides high-quality structured data to improve business outcomes and enable intelligent decision making, Our Web scraping service allows you to scrape data from any website and transfer web pages into an easy-to-use format such as Excel, CSV, JSON, and many others.