Question from Reddit user:
Hello /r/powerbi,
At my work we use pipedrive for sales and we recently acquired powerBI.
I really like the tool and have integrated google analytics into it, but I also would like to do pipedrive – however there is no option in the ‘Get Data’ feed.
Is it impossible to do?
Or do I have to do something less visible?
Thanks.
Answer from Nabil:
The short answer is:
No, it is not impossible to do, but you are absolutely correct – Pipedrive does not offer a simple, native connector in Power BI’s Get Data feed, which is why you can’t find it.
To connect Pipedrive, you have to use a “less visible” method that leverages its API.
The simplest way to start is by using the Web data connector in Power BI to call the Pipedrive API endpoints directly, but this gets complicated quickly due to data pagination and JSON complexity.
The best long-term solution is to use a dedicated data pipeline or integration service to automatically extract your Pipedrive data and stage it in a cloud data warehouse or a simple URL that Power BI can easily read.
The long answer is:
Your situation is very common because most CRMs, including Pipedrive, focus on their primary function and leave deep BI integration to specialized tools or custom development.
Since you already successfully integrated Google Analytics, you are familiar with the “Get Data” feed, but for Pipedrive, you need to use the Web connector and Power Query (M Language).
This involves creating a Web query in Power BI Desktop, using your Pipedrive API token in the URL, and then writing a custom Power Query script to handle the JSON response.
The tricky part is that Pipedrive’s API is paginated, meaning you have to write code that loops through multiple pages of data to pull your entire deal history, which is not straightforward.
To avoid this complex custom coding and ensure a reliable, automated data refresh, you should consider a modern, robust solution.
This involves creating a reliable data pipeline using the Pipedrive API to extract all your deals, persons, and organizations data, and then pushing this data directly to a staging environment like a cloud database, Google Sheets, or a secure endpoint.
You can achieve this using a dedicated ETL tool or a custom script running on a cloud service like Google Cloud Platform which automatically handles the API calls, pagination, and data transformation.
Once the data is staged, Power BI can easily connect to this stable source, either using a database connector or the Web connector to access the final structured data URL.
This method gives you complete control over data transformation before it hits Power BI, and ensures that your reports are always running on a complete and up-to-date dataset.
For a custom scenario that integrates various systems, you could even set up a cloud function to call the Pipedrive API and then push the processed data using the Power BI REST APIs to a streaming dataset or a push dataset in the Power BI Service, offering the most direct and real-time integration available without relying on third-party connectors.
About The Author
