Pipedrive to PowerBI

Alex Gero

Hello Pipedrive Community

Does anyone know if there is a way to connect Pipedrive to PowerBI? I need data within my opportunities to flow into our dashboard in PowerBI. From my research, it doesn't look like there is a direct API but has anyone found a workaround for this?

 

Thanks!

 

Alex

Amit Sarda (AmitSarda.xyz)

You can use Flatly or StitchData to read data from Pipedrive and push it to your Database, which can in turn be read from PowerBI.

Boris Tsibelman

To import data into a publish report, you can follow this toturial, Push data into a Power BI dashboard. Power BI Services provides the APIs that are also JSON based. Just call the Pipedrive API, reform and send the returned JSON to Power BI services, say in C#, and schedule a windows task to import in a certain interval automatically.

Michael Tomar

You can use Skyvia to connect Pipedrive and Power BI. You can either replicate Pipedrive data to DWH and then set up the connection to Power BI or share Pipedrive data as an OData endpoint. I hope it helps.

https://skyvia.com/data-integration/analyze-pipedrive-with-powerbi