Pipedrive to PowerBI

Alex Gero
Alex Gero Posts: 10
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

Tagged:

Comments

  • 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 Posts: 998
    1000 Comments Second Anniversary First Answer Combo Breaker
    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.