WooCommerce Power BI Connector — Documentation
The WooCommerce Power BI Connector syncs your store data — orders, products, customers, refunds, coupons, taxes, shipping, and more entities — directly into Microsoft Power BI. Build dashboards, embed reports in WordPress, and automate data refreshes without writing a single line of code.
| Feature | Details |
|---|---|
| 16 data types | Orders, Products, Customers, Refunds, Coupons, Taxes, Shipping, Inventory, and more |
| 3 sync modes | Live (real-time), Scheduled (cron), Manual (on-demand) |
| Embed reports | Shortcode and admin panel embedding with iframe/JS support |
| Alerts | Threshold-based email notifications for revenue, AOV, stock, refund rate |
| Security | Azure AD OAuth2, encrypted credentials, role-based access, audit trail |
| Automation | 24 REST API endpoints, 7 WP-CLI commands |
How It Works
WooCommerce → Plugin → Azure AD OAuth2 → Power BI REST API → Workspace/Dataset
- Register an app in Azure AD → get Client ID, Secret, Tenant ID
- Run the Setup Wizard → paste keys, authorize, pick a workspace
- Select data types → plugin creates tables and pushes rows in batches
- Build reports in Power BI → embed them back in WordPress via shortcode
Setup takes about 20 minutes. After that, sync runs automatically.
Quick Navigation
Getting Started
| Step | Page | What you do |
|---|---|---|
| 1 | Quick Start | 5-minute overview of the full setup |
| 2 | Installation | Upload ZIP, activate, verify requirements |
| 3 | Azure AD Setup | Create Azure app, copy Client ID / Secret / Tenant ID |
| 4 | Power BI Setup | Create workspace, set permissions, enable API |
| 5 | Setup Wizard | 7-step wizard — paste keys, authorize, first sync |
Configuration
Reports & Alerts
Data & Sync
Advanced
First-time users
Follow the pages in order: Installation → Azure AD Setup → Power BI Setup → Setup Wizard. You can come back to the feature pages later.