Power BI

Under Review

Salesforce dataset to connect to custom objects and fields

Vote (163)

Power BI User on 03 Jan 2015 04:57:07

First of all, very impressive with the features Power BI Public Preview, I have one question regarding the Salesforce Dataset though, can it connect to custom objects? I've looked but can't find where it can.

Thanks!

Administrator on 10 Mar 2015 05:51:29

At the moment we don't import custom objects (we have to request specific things through their API) but we could improve this in future. We could also import custom fields on their standard objects. Who else would find it useful? Please add your vote if you would!

Comments (29)

Comments (29)

avik on 06 Jul 2020 00:09:01

RE: Salesforce dataset to connect to custom objects and fields

Why no progress even after 5 years?

Damodara Moreira on 05 Jul 2020 23:36:43

RE: Salesforce dataset to connect to custom objects and fields

Has anyone found a solution that works for this? Please share!

Vijaya Narkar on 05 Jul 2020 23:29:51

RE: Salesforce dataset to connect to custom objects and fields

Any updated on this. Please share!

Teresa Fitzpatrick on 05 Jul 2020 23:29:35

RE: Salesforce dataset to connect to custom objects and fields

'@Simon - I would also be interested. Having issues refreshing Salesforce dataset in the PBI Service due to the limitation that one user can only run 10 queries at a time so keep getting the infamous "invalid query locator" error :( This is fixed on desktop by disabling parallel loading of tables.

Scott on 05 Jul 2020 23:29:27

RE: Salesforce dataset to connect to custom objects and fields

'@Simon - would be very interested in seeing the custom Salesforce connectors mentioned for custom SOQL + SF Metadata

Simon on 05 Jul 2020 23:24:50

RE: Salesforce dataset to connect to custom objects and fields

If anyone is interested, I've developed two custom Salesforce connectors that enable you to:

(1) Execute custom SOQL queries; and

(2) Extract Salesforce metadata

Ferdinand Santos on 05 Jul 2020 23:03:05

RE: Salesforce dataset to connect to custom objects and fields

Not sure if it falls in this same category but it will be useful also to be able to use a custom report type as a data source.

Power BI User on 05 Jul 2020 23:02:32

RE: Salesforce dataset to connect to custom objects and fields

Our company currently uses Domo BI, and I'm doing a comparison with Power BI.
We use both Salesforce and Dynamics AX (moving to D365).

The Domo ability to do a SOQL query is setting it apart from Power BI at this point.
A lot of the other features of Power BI are great, but we can't get to the SalesForce custom objects/data.

Lesley on 05 Jul 2020 23:00:56

RE: Salesforce dataset to connect to custom objects and fields

I would love to live link Salesforce to Power BI, but without custom fields, Power BI remains almost unusable for my work. Please help!

Jonathan Hunter on 05 Jul 2020 22:59:54

RE: Salesforce dataset to connect to custom objects and fields

This one seriously needs to happen. I could be entirely operating with a connection between Power BI Cloud and SFDC, however I can't because nearly all the tables I need to get to aren't available.

This would also solve my problem of having to do a local gateway to pull data down from SFDC to get these fields and make refreshing in general a better experience. If your offering a cloud service - direct, and fully functioning cloud connectors is a must, please don't limit us.