Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dhilanb
New Member

can't see Object "Account Contact Relationship

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

PBI can't find this object; any ideas? 

Thanks,

5 REPLIES 5
ReportMaster
Post Patron
Post Patron

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:

 

SALESFORCE-1.png

 

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:

 

SALESFORCE-2.png

 

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. 

 

SELECT_DESTINATION_NEW.png

dax
Community Support
Community Support

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.

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
Super User
Super User

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...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.