![\"WooCommerce\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/WooCommerce-logo.png\"){kind=logo}
<\/a>WooCommerce is one of the most widely used eCommerce platforms for WordPress websites. Store owners and analysts often need to combine WooCommerce order, product, and customer data with other business metrics in Power BI for reporting and decision-making. Using Zappysys ODBC Driver for REST APIs, you can connect WooCommerce to Power BI and query API data using SQL without custom coding.<\/p>\nThis tutorial demonstrates how to configure WooCommerce ODBC connectivity and load WooCommerce data into Power BI for interactive dashboards.<\/p>\n
Prerequisites<\/h2>\n\n- A WordPress site with WooCommerce installed.<\/li>\n
- Microsoft Power BI Desktop is installed on your machine.<\/li>\n
- Basic knowledge of ODBC and SQL queries.<\/li>\n
- Finally, install the ZappySys ODBC Driver<\/a>.<\/li>\n<\/ol>\n
Steps<\/h2>\nGenerate WooCommerce API Credentials<\/h3>\n\n- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, Power BI Integration<\/strong>), select a user, and set permissions to Read<\/strong> or Read\/Write<\/strong> as needed.<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Get-API-key.png\")
<\/a>Woocommerce – Get API key<\/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 WooCommerce API Connection<\/h3>\n\n- In the DSN configuration window, enter the base endpoint in Base URL<\/strong>:\n
https:\/\/your-website.com\/wp-json\/wc\/v3\/orders<\/pre>\n<\/li>\n
- Set Connection Type<\/strong> to HTTP<\/strong> and click to configure.<\/li>\n
- Select Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the password<\/b>\u00a0to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-ODBC-HTTP-connection.png\")
<\/a>Woocommerce – ODBC HTTP connection<\/p><\/div><\/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\/Woocommerce-ODBC-JSON-Driver-configuration.png\")
<\/a>Woocommerce – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview WooCommerce Data in ODBC Driver<\/h3>\n\n- Open the DSN and go to the Preview<\/strong> tab.<\/li>\n
- Click Preview Data<\/strong> to validate that WooCommerce order rows are visible.<\/li>\n
- If rows are not returned, check the store URL, credentials, SSL, and API permissions.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-ODBC-Preview-data.png\")
<\/a>Woocommerce – ODBC Preview data<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to WooCommerce 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 WooCommerce ODBC DSN from the dropdown.<\/li>\n
- Optionally, enter a custom SQL query in Advanced options<\/strong>.<\/li>\n
- Click OK<\/strong>, then click Load<\/strong> to import data.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Power-Bi-select-connection.png\")
<\/a>Woocommerce – Power BI select connection<\/p><\/div><\/li>\n
- Verify the result and click Load<\/strong>.\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Power-BI-load-the-data.png\")
<\/a>Woocommerce – Power BI loads the data<\/p><\/div><\/li>\n
- In the Navigator window, select the columns you want to load.\n<\/div>\n
![\"\"](\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2026\/06\/Woocommerce-Power-BI-final-result.png\")
<\/a>Woocommerce – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
By connecting WooCommerce to Power BI through the ZappySys ODBC REST\/JSON driver, you can quickly turn raw store API data into interactive dashboards. This approach simplifies integration by allowing you to use SQL for data extraction and Power BI for modelling and visualisation.<\/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 GitHub 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
Steps<\/h2>\nGenerate WooCommerce API Credentials<\/h3>\n\n- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, Power BI Integration<\/strong>), select a user, and set permissions to Read<\/strong> or Read\/Write<\/strong> as needed.<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n<\/a>
Woocommerce – Get API key<\/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 WooCommerce API Connection<\/h3>\n\n- In the DSN configuration window, enter the base endpoint in Base URL<\/strong>:\n
https:\/\/your-website.com\/wp-json\/wc\/v3\/orders<\/pre>\n<\/li>\n
- Set Connection Type<\/strong> to HTTP<\/strong> and click to configure.<\/li>\n
- Select Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the password<\/b>\u00a0to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n<\/a>
Woocommerce – ODBC HTTP connection<\/p><\/div><\/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>
Woocommerce – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview WooCommerce Data in ODBC Driver<\/h3>\n\n- Open the DSN and go to the Preview<\/strong> tab.<\/li>\n
- Click Preview Data<\/strong> to validate that WooCommerce order rows are visible.<\/li>\n
- If rows are not returned, check the store URL, credentials, SSL, and API permissions.\n<\/a>
Woocommerce – ODBC Preview data<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to WooCommerce 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 WooCommerce ODBC DSN from the dropdown.<\/li>\n
- Optionally, enter a custom SQL query in Advanced options<\/strong>.<\/li>\n
- Click OK<\/strong>, then click Load<\/strong> to import data.\n<\/a>
Woocommerce – Power BI select connection<\/p><\/div><\/li>\n
- Verify the result and click Load<\/strong>.\n<\/a>
Woocommerce – Power BI loads the data<\/p><\/div><\/li>\n
- In the Navigator window, select the columns you want to load.\n<\/div>\n<\/a>
Woocommerce – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
By connecting WooCommerce to Power BI through the ZappySys ODBC REST\/JSON driver, you can quickly turn raw store API data into interactive dashboards. This approach simplifies integration by allowing you to use SQL for data extraction and Power BI for modelling and visualisation.<\/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 GitHub 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
- Sign in to your WordPress<\/a> admin dashboard.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n
- Click Add key<\/strong>.<\/li>\n
- Enter a description (for example, Power BI Integration<\/strong>), select a user, and set permissions to Read<\/strong> or Read\/Write<\/strong> as needed.<\/li>\n
- Click Generate API key<\/strong>.<\/li>\n
- Copy the Consumer Key<\/strong> and Consumer Secret<\/strong>, then store them securely.\n
<\/a>Woocommerce – Get API key<\/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 WooCommerce API Connection<\/h3>\n
- \n
- In the DSN configuration window, enter the base endpoint in Base URL<\/strong>:\n
https:\/\/your-website.com\/wp-json\/wc\/v3\/orders<\/pre>\n<\/li>\n
- Set Connection Type<\/strong> to HTTP<\/strong> and click to configure.<\/li>\n
- Select Basic Auth (Username\/Password)<\/strong>.<\/li>\n
- Set Username<\/strong> to your WooCommerce Consumer Key<\/strong>.<\/li>\n
- Set the password<\/b>\u00a0to your WooCommerce Consumer Secret<\/strong>.<\/li>\n
- Click OK<\/strong> to save the connection.\n
<\/a>Woocommerce – ODBC HTTP connection<\/p><\/div><\/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>Woocommerce – ODBC JSON Driver configuration<\/p><\/div><\/li>\n<\/ol>\n
Preview WooCommerce Data in ODBC Driver<\/h3>\n
- \n
- Open the DSN and go to the Preview<\/strong> tab.<\/li>\n
- Click Preview Data<\/strong> to validate that WooCommerce order rows are visible.<\/li>\n
- If rows are not returned, check the store URL, credentials, SSL, and API permissions.\n
<\/a>Woocommerce – ODBC Preview data<\/p><\/div><\/li>\n<\/ol>\n
Connect Power BI to WooCommerce 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 WooCommerce ODBC DSN from the dropdown.<\/li>\n
- Optionally, enter a custom SQL query in Advanced options<\/strong>.<\/li>\n
- Click OK<\/strong>, then click Load<\/strong> to import data.\n
<\/a>Woocommerce – Power BI select connection<\/p><\/div><\/li>\n
- Verify the result and click Load<\/strong>.\n
<\/a>Woocommerce – Power BI loads the data<\/p><\/div><\/li>\n
- In the Navigator window, select the columns you want to load.\n
<\/div>\n<\/a>Woocommerce – Power BI final result<\/p><\/div><\/li>\n<\/ol>\n
Conclusion<\/h2>\n
By connecting WooCommerce to Power BI through the ZappySys ODBC REST\/JSON driver, you can quickly turn raw store API data into interactive dashboards. This approach simplifies integration by allowing you to use SQL for data extraction and Power BI for modelling and visualisation.<\/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 GitHub 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
- Click Preview Data<\/strong> to validate that WooCommerce order rows are visible.<\/li>\n
- Set Connection Type<\/strong> to HTTP<\/strong> and click to configure.<\/li>\n
- In the User DSN<\/strong> or System DSN<\/strong> tab, click Add<\/strong>.<\/li>\n
- Go to WooCommerce<\/strong> > Settings<\/strong> > Advanced<\/strong> > REST API<\/strong>.<\/li>\n