Connecting Bullhorn or Salesforce to Power Bi

[Peppearson]

Hi,

I'm trying to look into how easy/difficult it is to connect from Power Bi to either Salesforce or Bullhorn CRMs i.e. are there any particular limitations.

Currently I'm connected to Microsoft Dynamics via it's API using Odata feed in Power Bi.

Does anyone know if the process is similar to Salesforce/Bullhorn

Thanks.

[v-rzhou-msft · Accepted solution]

Hi @Peppearson ,

As far as I know, currently Power BI doesn't support us to connect to Bullhorn directly. However Power BI support us to connect to Salesforce by Salesforce Object/ Salesforce Report connector.

For reference:

How to Connect Salesforce to Power BI

If you want to connect to Bullhorn or Salesforce by REST API, please make sure whether they support REST API.

For reference:

Using a REST API as a data source

Or you can pull data via their open REST API. Here is a link to Bullhorn API documentation, which will get you started. 

You can build an ETL package which dumps the data into a SQL DB and pulls down modified records every hour and updates/inserts.

Then point Power BI at the SQL tables (import) or (Direct) for live reports, using the on promise data gateway to automatically pull the most recent data when the report is loaded in PowerBi.com.

Best Regards,
Rico Zhou

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