can't see Object "Account Contact Relationship

[dhilanb]

Hi there,
in PBI Desktop i can't see the object "Account Contact Relationship".

PBI can't find this object; any ideas? 

Thanks,

[ReportMaster]

Hi @dhilanb were you able to find a solution? I've used the Salesforce connector but I had some issues with my data too. As a workaround, maybe you can try to test your connection using a 3rd party connector. I currently use windsor.ai's SF connector which is also compatible with SF objects and custom fields. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[dax]

Hi @dhilanb ,

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dhilanb]

Hi there,

Apologies for the brief query. This is to with PowerBI and Salesforce.

I have a Salesforce object I can see; “Account Contact Relationship”

I can’t however see this data on the PBI desktop version when I “Get Data”, I can see all the other objects.

Funnily enough Tableau is able to get this data but PBI Desktop cannot.

Cheers,

Dhilan

[amitchandak]

The information you have provided is not making the problem clear to me. Can you please explain with an example. If possible please share a sample pbix file after removing sensitive information.
Thanks.

My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[dhilanb]

Hi there,

Apologies for the brief query. This is to with PowerBI and Salesforce.

I have a Salesforce object I can see; “Account Contact Relationship”

I can’t however see this data on the PBI desktop version when I “Get Data”, I can see all the other objects.

Funnily enough Tableau is able to get this data but PBI Desktop cannot.

Cheers,

Dhilan