Pipedrive to PowerBI

Alex Gero
Alex Gero Posts: 13
edited July 25 in Sales CRM #1

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

Tagged:

Comments

  • Amit Sarda - Pipedrive Consultant - AmitSarda.xyz
    edited August 2021 #2

    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
    Boris Tsibelman Community Driver Posts: 1,037
    1000 Comments Second Anniversary Combo Breaker Photogenic
    edited August 2021 #3

    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.