Pipedrive to PowerBI

Alex Gero
Alex Gero Member Posts: 8 VERIFIED MEMBER
First Comment
edited July 2022 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

Comments

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,609 VERIFIED MEMBER
    1000 Comments 250 Likes Fourth Anniversary 25 Answers
    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 Member Posts: 827 VERIFIED MEMBER
    1000 Comments Third Anniversary 5 Likes First Answer
    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.

  • Michael Tomar
    Michael Tomar Member Posts: 14 VERIFIED MEMBER
    Second Anniversary 10 Comments Photogenic
    #4

    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


This discussion has been closed.

Categories