Forum Discussion
Connecting Bullhorn or Salesforce to Power Bi
- Anonymous3 years ago
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.