![\"Pipedrive\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/pipedrive-logo-150x150.png\"){kind=logo}
<\/a>Pipedrive is a CRM platform used by sales teams to manage leads, deals, contacts, activities, and pipelines. Many organisations need this data in Power BI to monitor sales performance, pipeline health, conversion rates, and team productivity.<\/p>\nUsing ZappySys ODBC Driver for REST APIs, you can connect to Pipedrive APIs, query CRM data with SQL, and load it directly into Power BI dashboards without writing custom connector code.<\/p>\n
This tutorial shows how to create an ODBC DSN for Pipedrive API, preview data, connect to Power BI, and build analytics using custom SQL queries.<\/p>\n
<\/h3>\nPrerequisites<\/h2>\n\n- A Pipedrive account with API access enabled.<\/li>\n
- Power BI Desktop is installed on your machine.<\/li>\n
- Basic understanding of SQL and Power BI data modelling.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\nGet Pipedrive API token<\/h3>\n\n- Sign in to your Pipedrive account.<\/li>\n
- Go to Personal Preferences<\/strong> and open API<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-Personal-token.png\")
<\/a>Pipedrive – Personal token<\/p><\/div><\/li>\n<\/ol>\n
Create a new ODBC DSN using ZappySys JSON Driver<\/h3>\n\n- Search for ODBC<\/strong> in the Windows Start menu and open ODBC Data Source Administrator<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/how-to-open-odbc-data-source-administrator-2.png\")
<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong>.<\/li>\n
- Select ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/01\/odbc-dsn-admin-create-dsn-based-on-json-driver.png\")
<\/a><\/li>\n<\/ol>\nConfigure the Connection and API Settings<\/h3>\n\n- Enter the base URL:
\nhttps:\/\/api.pipedrive.com\/v1\/deals?api_token={your_api_token}<\/span><\/span><\/li>\n- Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Test Connection<\/strong> to verify connectivity, then click OK<\/strong> to save the DSN.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-JSON-Driver-configuration.png\")
<\/a>Pipedrive – JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview Pipedrive data in ODBC Driver<\/h3>\n\n- Go to the Preview<\/strong> tab.<\/li>\n
- Generate a query, then click Preview Data<\/strong> to confirm rows are returned.<\/li>\n
- If no data is returned, verify your API token, endpoint URL, and JSON Path Filter.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-JSON-Driver-result.png\")
<\/a>Pipedrive – JSON Driver result<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to Pipedrive via ODBC<\/h3>\n\n- Open Power BI Desktop<\/strong>.<\/li>\n
- Click Get Data<\/strong> from the Home ribbon.<\/li>\n
- Click More…<\/strong>, search for ODBC<\/strong>, and click Connect<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Power-BI-Get-data-from-ODBC-connection.png\")
<\/a>Power BI – Get data from ODBC connection<\/p><\/div><\/li>\n
- Select your Pipedrive ODBC DSN from the dropdown list.<\/li>\n
- Optionally, enter a custom SQL query in Advanced options<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-Power-BI-select-driver.png\")
<\/a>Pipedrive – Power BI select driver<\/p><\/div><\/li>\n
- Click OK<\/strong>, then click Load<\/strong> to import data.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Pipedrive-Power-BI-preview.png\")
<\/a>Pipedrive – Power BI preview<\/p><\/div><\/li>\n
- In the Navigator window, select the columns you want to load.<\/li>\n<\/ol>\n
Query Pipedrive data with SQL<\/h3>\n
For advanced analytics, use custom SQL queries in Power BI or the ODBC tool.<\/p>\n
Example 1: List All Deals<\/strong><\/p>\nSELECT \r\n id,\r\n title,\r\n value,\r\n currency,\r\n status,\r\n stage_id,\r\n add_time,\r\n update_time\r\nFROM data<\/pre>\nExample 2: Open Deals Only<\/strong><\/p>\nSELECT \r\n id,\r\n title,\r\n value,\r\n currency,\r\n stage_id,\r\n expected_close_date\r\nFROM data\r\nWHERE status = 'open'<\/pre>\nExample 3: Won Deals Summary<\/strong><\/p>\nSELECT \r\n currency,\r\n COUNT(*) AS WonDeals,\r\n SUM(value) AS TotalWonValue,\r\n AVG(value) AS AvgWonValue\r\nFROM data\r\nWHERE status = 'won'\r\nGROUP BY currency<\/pre>\nExample 4: Deals Updated in Last 30 Days<\/strong><\/p>\nSELECT \r\n id,\r\n title,\r\n status,\r\n update_time\r\nFROM data\r\nWHERE update_time >= DATEADD(DAY, -30, GETDATE())<\/pre>\nExample 5: Deal Count by Stage<\/strong><\/p>\nSELECT \r\n stage_id,\r\n COUNT(*) AS DealCount,\r\n SUM(value) AS TotalValue\r\nFROM data\r\nGROUP BY stage_id\r\nORDER BY DealCount DESC<\/pre>\nExample 6: Expected Revenue by Close Date<\/strong><\/p>\nSELECT \r\n expected_close_date,\r\n COUNT(*) AS DealCount,\r\n SUM(value) AS ExpectedRevenue\r\nFROM data\r\nWHERE status = 'open'\r\n AND expected_close_date IS NOT NULL\r\nGROUP BY expected_close_date\r\nORDER BY expected_close_date<\/pre>\nConclusion<\/h2>\n
Connecting Pipedrive to Power BI using ZappySys ODBC Driver makes it easy to build CRM analytics dashboards without building custom connectors. With SQL-based access to Pipedrive API responses, you can monitor pipeline performance, deal progression, and sales activity in one place.<\/p>\n
Explore the full capabilities of the Zappysys ODBC Drivers<\/a> to integrate multiple data sources and build comprehensive Power BI dashboards. By combining Pipedrive data with other sources, you can create unified views of your operational data.<\/p>\nNeed help?<\/h2>\n
If you encounter any issues, our support team is here to help:<\/p>\n
- \n
- A Pipedrive account with API access enabled.<\/li>\n
- Power BI Desktop is installed on your machine.<\/li>\n
- Basic understanding of SQL and Power BI data modelling.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\n
Get Pipedrive API token<\/h3>\n
- \n
- Sign in to your Pipedrive account.<\/li>\n
- Go to Personal Preferences<\/strong> and open API<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n
<\/a>Pipedrive – Personal token<\/p><\/div><\/li>\n<\/ol>\n
Create a new ODBC DSN using ZappySys JSON Driver<\/h3>\n
- \n
- Search for ODBC<\/strong> in the Windows Start menu and open ODBC Data Source Administrator<\/strong>.
\n<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong>.<\/li>\n
- Select ZappySys JSON Driver<\/strong> and click Continue<\/strong>.
\n<\/a><\/li>\n<\/ol>\nConfigure the Connection and API Settings<\/h3>\n
- \n
- Enter the base URL:
\nhttps:\/\/api.pipedrive.com\/v1\/deals?api_token={your_api_token}<\/span><\/span><\/li>\n- Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- Set JSON Path Filter<\/strong> to:\n
$.data[*]<\/pre>\n<\/li>\n
- Click Test Connection<\/strong> to verify connectivity, then click OK<\/strong> to save the DSN.\n
<\/a>Pipedrive – JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview Pipedrive data in ODBC Driver<\/h3>\n
- \n
- Go to the Preview<\/strong> tab.<\/li>\n
- Generate a query, then click Preview Data<\/strong> to confirm rows are returned.<\/li>\n
- If no data is returned, verify your API token, endpoint URL, and JSON Path Filter.\n
<\/a>Pipedrive – JSON Driver result<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to Pipedrive via ODBC<\/h3>\n
- \n
- Open Power BI Desktop<\/strong>.<\/li>\n
- Click Get Data<\/strong> from the Home ribbon.<\/li>\n
- Click More…<\/strong>, search for ODBC<\/strong>, and click Connect<\/strong>.\n
<\/a>Power BI – Get data from ODBC connection<\/p><\/div><\/li>\n
- Select your Pipedrive ODBC DSN from the dropdown list.<\/li>\n
- Optionally, enter a custom SQL query in Advanced options<\/strong>.\n
<\/a>Pipedrive – Power BI select driver<\/p><\/div><\/li>\n
- Click OK<\/strong>, then click Load<\/strong> to import data.\n
<\/a>Pipedrive – Power BI preview<\/p><\/div><\/li>\n
- In the Navigator window, select the columns you want to load.<\/li>\n<\/ol>\n
Query Pipedrive data with SQL<\/h3>\n
For advanced analytics, use custom SQL queries in Power BI or the ODBC tool.<\/p>\n
Example 1: List All Deals<\/strong><\/p>\n
SELECT \r\n id,\r\n title,\r\n value,\r\n currency,\r\n status,\r\n stage_id,\r\n add_time,\r\n update_time\r\nFROM data<\/pre>\n
Example 2: Open Deals Only<\/strong><\/p>\n
SELECT \r\n id,\r\n title,\r\n value,\r\n currency,\r\n stage_id,\r\n expected_close_date\r\nFROM data\r\nWHERE status = 'open'<\/pre>\n
Example 3: Won Deals Summary<\/strong><\/p>\n
SELECT \r\n currency,\r\n COUNT(*) AS WonDeals,\r\n SUM(value) AS TotalWonValue,\r\n AVG(value) AS AvgWonValue\r\nFROM data\r\nWHERE status = 'won'\r\nGROUP BY currency<\/pre>\n
Example 4: Deals Updated in Last 30 Days<\/strong><\/p>\n
SELECT \r\n id,\r\n title,\r\n status,\r\n update_time\r\nFROM data\r\nWHERE update_time >= DATEADD(DAY, -30, GETDATE())<\/pre>\n
Example 5: Deal Count by Stage<\/strong><\/p>\n
SELECT \r\n stage_id,\r\n COUNT(*) AS DealCount,\r\n SUM(value) AS TotalValue\r\nFROM data\r\nGROUP BY stage_id\r\nORDER BY DealCount DESC<\/pre>\n
Example 6: Expected Revenue by Close Date<\/strong><\/p>\n
SELECT \r\n expected_close_date,\r\n COUNT(*) AS DealCount,\r\n SUM(value) AS ExpectedRevenue\r\nFROM data\r\nWHERE status = 'open'\r\n AND expected_close_date IS NOT NULL\r\nGROUP BY expected_close_date\r\nORDER BY expected_close_date<\/pre>\n
Conclusion<\/h2>\n
Connecting Pipedrive to Power BI using ZappySys ODBC Driver makes it easy to build CRM analytics dashboards without building custom connectors. With SQL-based access to Pipedrive API responses, you can monitor pipeline performance, deal progression, and sales activity in one place.<\/p>\n
Explore the full capabilities of the Zappysys ODBC Drivers<\/a> to integrate multiple data sources and build comprehensive Power BI dashboards. By combining Pipedrive data with other sources, you can create unified views of your operational data.<\/p>\n
Need help?<\/h2>\n
If you encounter any issues, our support team is here to help:<\/p>\n
- Click Get Data<\/strong> from the Home ribbon.<\/li>\n
- Generate a query, then click Preview Data<\/strong> to confirm rows are returned.<\/li>\n
- Set HTTP Request Method<\/strong> to GET<\/strong>.<\/li>\n
- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong>.<\/li>\n
- Copy your API token and store it securely.\n