![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/notion-logo.png\"){kind=logo}
<\/a>Notion is a versatile workspace platform that many teams use to manage projects, tasks, documentation, and databases. However, to leverage this data for advanced analytics and business intelligence, you need to connect it to tools like Power BI. Using Zappysys ODBC Driver for Notion, you can seamlessly extract data from Notion databases and visualize it in Power BI without writing any code.<\/p>\nThis tutorial demonstrates how to set up a connection from Notion to Power BI using the Zappysys ODBC driver, query your Notion databases, and create interactive Power BI dashboards.<\/p>\n
<\/h3>\nPrerequisites<\/h2>\n\n- A Notion workspace with at least one database and records.<\/li>\n
- Notion API token (Personal Access Token or Integration token).<\/li>\n
- Power BI Desktop is installed on your system.<\/li>\n
- Basic understanding of Power BI and SQL queries.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\nCreate a Notion Integration and Token<\/h3>\n\n- Go to Notion Integrations<\/a> and sign in.<\/li>\n
- Go to the My Integrations<\/strong> section and click New Integration<\/strong>.<\/li>\n
- Enter a name for your integration and select the target workspace.<\/li>\n
- Click Create connection<\/strong> to proceed.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Create-a-new-connection.png\")
<\/a>Notion – Create a new connection<\/p><\/div><\/li>\n
- Configure the capabilities you need by checking or unchecking the relevant options.<\/li>\n
- Copy the generated Access Token<\/strong> and store it securely. You’ll need this token to configure the ODBC driver.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Configure-new-token.png\")
<\/a>Notion – Configure new token<\/p><\/div><\/li>\n<\/ol>\n
Connect Your Notion Database to the Integration<\/h3>\n\n- Open your target Notion database page in the browser.<\/li>\n
- Click …<\/strong> in the top-right corner.<\/li>\n
- Click Connections<\/strong>, search for your integration, and select it.<\/li>\n
- Confirm access to the connection.<\/li>\n
- Copy the database ID from the URL. For example:
\nhttps:\/\/app.notion.com\/p\/<DATABASE_ID>?v=......................
\n<\/code><\/p>\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Set-a-connection-to-your-table.png\")
<\/a>Notion – Set a connection to your table<\/p><\/div><\/li>\n<\/ol>\n
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n\n- Search for ODBC<\/strong> in the Windows Start menu and open the 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> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the 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 for the table:
\nhttps:\/\/api.notion.com\/v1\/databases\/{{User::DatabaseId}}\/query<\/code><\/li>\n- In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
- Select Static Token\/API Key<\/strong> as the\u00a0Credential type.<\/strong><\/li>\n
- Paste your Notion Access Token<\/strong> in the authentication field.<\/li>\n
- Click OK<\/strong> to save the configuration.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-ODBC-Connection-configuration.png\")
<\/a>Notion – ODBC Connection configuration<\/p><\/div><\/li>\n
- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Under headers, add: Notion-Version: {NotionVersion}<\/strong>. (Example: 2022-06-28)<\/li>\n
- Set JSON Path Filter<\/strong> to extract the object array. Example: $.results[*]<\/strong><\/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\/05\/Notion-ODBC-JSON-driver-configuration.png\")
<\/a>Notion – ODBC JSON driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview Notion table data in the ODBC Driver<\/h3>\n\n- Go to the Preview<\/strong> tab.<\/li>\n
- Select a table, generate a query, and then click Preview Data<\/strong> to confirm that database records are returned.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-ODBC-JSON-driver-result.png\")
<\/a>Notion – ODBC JSON driver result<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to Notion via ODBC<\/h3>\n\n- Open Power BI Desktop<\/strong>.<\/li>\n
- Click Get Data<\/strong> in the Home ribbon.<\/li>\n
- Click More…<\/strong> and search for ODBC<\/strong>.<\/li>\n
- Click Connect<\/strong>.\n<\/div>\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
- From the dropdown, select the Notion<\/strong> ODBC data source you created earlier.<\/li>\n
- You can enter a custom query that you used in the ODBC JSON driver.<\/li>\n
- Click OK<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Power-BI-connection.png\")
<\/a>Notion – Power BI connection<\/p><\/div><\/li>\n
- Click Load<\/strong> to import the data into Power BI.
\n![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Power-BI-table.png\")
<\/a><\/li>\n- In the Navigator window, select the Notion columns you want to load.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/05\/Notion-Power-BI-final-result.png\")
<\/a>Notion – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n
Query Notion Data with SQL<\/h3>\n
For more advanced scenarios, you can write custom SQL queries to extract specific data from your Notion database. Here are some common query examples:<\/p>\n
Example 1: Extract All Database Records<\/strong><\/p>\nSELECT \r\n Id,\r\n Title,\r\n Status,\r\n CreatedTime,\r\n LastEditedTime\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'<\/pre>\nExample 2: Filter Records by Status<\/strong><\/p>\nSELECT \r\n Id,\r\n Title,\r\n Status,\r\n Priority,\r\n DueDate\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\n AND Status = 'In Progress'<\/pre>\nExample 3: Count Records by Status<\/strong><\/p>\nSELECT \r\n Status,\r\n COUNT(*) AS RecordCount\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\nGROUP BY Status<\/pre>\nExample 4: Get Recent Records (Last 30 Days)<\/strong><\/p>\nSELECT \r\n Id,\r\n Title,\r\n Status,\r\n CreatedTime\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\n AND CreatedTime >= DATEADD(DAY, -30, CAST(GETDATE() AS DATE))<\/pre>\nExample 5: Join Multiple Database Properties<\/strong><\/p>\nSELECT \r\n d.Id,\r\n d.Title,\r\n d.AssignedTo,\r\n d.Status,\r\n d.DueDate\r\nFROM Databases d\r\nWHERE d.DatabaseId = 'YOUR_DATABASE_ID'\r\n AND d.AssignedTo IS NOT NULL<\/pre>\nExample 6: Aggregate Data by Multiple Dimensions<\/strong><\/p>\nSELECT \r\n Status,\r\n Priority,\r\n COUNT(*) AS TaskCount,\r\n AVG(CAST(Duration AS FLOAT)) AS AvgDuration\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\nGROUP BY Status, Priority<\/pre>\nConclusion<\/h2>\n
Connecting Notion to Power BI using the Zappysys ODBC Driver provides a seamless way to bring your workspace data into a powerful analytics platform. With SQL queries, DAX measures, and visualisations, you can unlock insights from your Notion databases and create compelling business intelligence reports.<\/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 Notion 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 Notion workspace with at least one database and records.<\/li>\n
- Notion API token (Personal Access Token or Integration token).<\/li>\n
- Power BI Desktop is installed on your system.<\/li>\n
- Basic understanding of Power BI and SQL queries.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\n
Create a Notion Integration and Token<\/h3>\n
- \n
- Go to Notion Integrations<\/a> and sign in.<\/li>\n
- Go to the My Integrations<\/strong> section and click New Integration<\/strong>.<\/li>\n
- Enter a name for your integration and select the target workspace.<\/li>\n
- Click Create connection<\/strong> to proceed.\n
<\/a>Notion – Create a new connection<\/p><\/div><\/li>\n
- Configure the capabilities you need by checking or unchecking the relevant options.<\/li>\n
- Copy the generated Access Token<\/strong> and store it securely. You’ll need this token to configure the ODBC driver.\n
<\/a>Notion – Configure new token<\/p><\/div><\/li>\n<\/ol>\n
Connect Your Notion Database to the Integration<\/h3>\n
- \n
- Open your target Notion database page in the browser.<\/li>\n
- Click …<\/strong> in the top-right corner.<\/li>\n
- Click Connections<\/strong>, search for your integration, and select it.<\/li>\n
- Confirm access to the connection.<\/li>\n
- Copy the database ID from the URL. For example:
\nhttps:\/\/app.notion.com\/p\/<DATABASE_ID>?v=......................
\n<\/code><\/p>\n<\/a>Notion – Set a connection to your table<\/p><\/div><\/li>\n<\/ol>\n
Creating a new ODBC DSN using ZappySys JSON Driver<\/h3>\n
- \n
- Search for ODBC<\/strong> in the Windows Start menu and open the ODBC Data Source Administrator<\/strong>.
\n<\/a><\/li>\n- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- In the ODBC Data Source Setup<\/strong> window, select the 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 for the table:
\nhttps:\/\/api.notion.com\/v1\/databases\/{{User::DatabaseId}}\/query<\/code><\/li>\n- In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
- Select Static Token\/API Key<\/strong> as the\u00a0Credential type.<\/strong><\/li>\n
- Paste your Notion Access Token<\/strong> in the authentication field.<\/li>\n
- Click OK<\/strong> to save the configuration.\n
<\/a>Notion – ODBC Connection configuration<\/p><\/div><\/li>\n
- Set HTTP Request Method<\/strong> to POST<\/strong>.<\/li>\n
- Set Body content type<\/strong> to JSON (application\/json)<\/strong>.<\/li>\n
- Under headers, add: Notion-Version: {NotionVersion}<\/strong>. (Example: 2022-06-28)<\/li>\n
- Set JSON Path Filter<\/strong> to extract the object array. Example: $.results[*]<\/strong><\/li>\n
- Click Test Connection<\/strong> to verify connectivity, then click OK<\/strong> to save the DSN\n
<\/a>Notion – ODBC JSON driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview Notion table data in the ODBC Driver<\/h3>\n
- \n
- Go to the Preview<\/strong> tab.<\/li>\n
- Select a table, generate a query, and then click Preview Data<\/strong> to confirm that database records are returned.\n
<\/a>Notion – ODBC JSON driver result<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to Notion via ODBC<\/h3>\n
- \n
- Open Power BI Desktop<\/strong>.<\/li>\n
- Click Get Data<\/strong> in the Home ribbon.<\/li>\n
- Click More…<\/strong> and search for ODBC<\/strong>.<\/li>\n
- Click Connect<\/strong>.\n
<\/div>\n<\/a>Power BI – Get data from ODBC connection<\/p><\/div><\/li>\n
- From the dropdown, select the Notion<\/strong> ODBC data source you created earlier.<\/li>\n
- You can enter a custom query that you used in the ODBC JSON driver.<\/li>\n
- Click OK<\/strong>.\n
<\/a>Notion – Power BI connection<\/p><\/div><\/li>\n
- Click Load<\/strong> to import the data into Power BI.
\n<\/a><\/li>\n- In the Navigator window, select the Notion columns you want to load.\n
<\/a>Notion – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n
Query Notion Data with SQL<\/h3>\n
For more advanced scenarios, you can write custom SQL queries to extract specific data from your Notion database. Here are some common query examples:<\/p>\n
Example 1: Extract All Database Records<\/strong><\/p>\n
SELECT \r\n Id,\r\n Title,\r\n Status,\r\n CreatedTime,\r\n LastEditedTime\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'<\/pre>\n
Example 2: Filter Records by Status<\/strong><\/p>\n
SELECT \r\n Id,\r\n Title,\r\n Status,\r\n Priority,\r\n DueDate\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\n AND Status = 'In Progress'<\/pre>\n
Example 3: Count Records by Status<\/strong><\/p>\n
SELECT \r\n Status,\r\n COUNT(*) AS RecordCount\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\nGROUP BY Status<\/pre>\n
Example 4: Get Recent Records (Last 30 Days)<\/strong><\/p>\n
SELECT \r\n Id,\r\n Title,\r\n Status,\r\n CreatedTime\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\n AND CreatedTime >= DATEADD(DAY, -30, CAST(GETDATE() AS DATE))<\/pre>\n
Example 5: Join Multiple Database Properties<\/strong><\/p>\n
SELECT \r\n d.Id,\r\n d.Title,\r\n d.AssignedTo,\r\n d.Status,\r\n d.DueDate\r\nFROM Databases d\r\nWHERE d.DatabaseId = 'YOUR_DATABASE_ID'\r\n AND d.AssignedTo IS NOT NULL<\/pre>\n
Example 6: Aggregate Data by Multiple Dimensions<\/strong><\/p>\n
SELECT \r\n Status,\r\n Priority,\r\n COUNT(*) AS TaskCount,\r\n AVG(CAST(Duration AS FLOAT)) AS AvgDuration\r\nFROM Databases\r\nWHERE DatabaseId = 'YOUR_DATABASE_ID'\r\nGROUP BY Status, Priority<\/pre>\n
Conclusion<\/h2>\n
Connecting Notion to Power BI using the Zappysys ODBC Driver provides a seamless way to bring your workspace data into a powerful analytics platform. With SQL queries, DAX measures, and visualisations, you can unlock insights from your Notion databases and create compelling business intelligence reports.<\/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 Notion 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> in the Home ribbon.<\/li>\n
- Select a table, generate a query, and then click Preview Data<\/strong> to confirm that database records are returned.\n
- In Connection Type<\/strong>, select HTTP<\/strong> and click Configure<\/strong>.<\/li>\n
- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong> to create a new data source.<\/li>\n
- Click Connections<\/strong>, search for your integration, and select it.<\/li>\n
- Go to the My Integrations<\/strong> section and click New Integration<\/strong>.<\/li>\n
- Go to Notion Integrations<\/a> and sign in.<\/li>\n