AppsPricingBlogTry it
WooCommerce logo
Microsoft Power BI logo

Connect WooCommerce to Microsoft Power BI

Build an AI agent that works across WooCommerce and Microsoft Power BI, on a schedule or when you click Run.

22 source actions
15 target actions
Reverse direction supported

Why Connect WooCommerce & Microsoft Power BI?

Read what you need from WooCommerce

Your agent uses WooCommerce's documented actions to pull the records it needs, each time it runs.

Run a Microsoft Power BI action

Then it uses one of 15 documented actions, such as Add Rows to Dataset Table, Add Rows To Push Dataset, Cancel Dataset Refresh.

Test it, then put it on a schedule

Run it once on your own data and check the result. Then set it to run daily, on weekdays or weekly.

Available Triggers & Actions

WooCommerce logo

WooCommerce

Triggers (4)

New Coupon Event (Instant)

Emit new event each time the specified coupon event(s) occur

webhook
New Customer Event (Instant)

Emit new event each time the specified customer event(s) occur

webhook
New Order Event (Instant)

Emit new event each time the specified order event(s) occur

webhook
New Product Event (Instant)

Emit new event each time the specified product event(s) occur

webhook

Actions (22)

Add Order Note

Create a new note for an order. See the docs

Create Customer

Creates a new customer. See the docs

Create Order

Creates a new order. See the docs

Create Product

Creates a new product. See the docs

Create Refund

Create a new refund for an order. See the docs

Delete Order

Delete an existing order. See the docs

Get Customer

Retrieve a specific customer. See the docs

Get Order

Retrieve a specific order. See the docs

Get Order Note

Retrieve a specific order note. See the docs

Get Product

Retrieve a specific product. See the docs

List Categories Options

Retrieves available options for the Categories field.

List Customer Options

Retrieves available options for the Customer field.

List Order ID Options

Retrieves available options for the Order ID field.

List Order Notes

Retrieve a list of notes for a specific order. See the docs

List Orders

Retrieve a list of orders. See the docs

List Payment Method Options

Retrieves available options for the Payment Method field.

List Product ID Options

Retrieves available options for the Product ID field.

List Products

Retrieve a list of products. See the docs

List Products Options

Retrieves available options for the Products field.

Search Customers

Finds a customer by searching. See the docs

Update Order Status

Update the status of a specific order. See the docs

Update Product

Updates a product. See the docs

Microsoft Power BI logo

Microsoft Power BI

Triggers (3)

Dataset Refresh Completed

Emit new event when a dataset refresh operation has completed. See the documentation

polling
Dataset Refresh Failed

Emit new event when a dataset refresh operation has failed in Power BI. See the documentation

polling
New Dataset Refresh Created

Emit new event when a new dataset refresh operation is created. See the documentation

polling

Actions (15)

Add Rows to Dataset Table

Adds new data rows to the specified table within the specified dataset from My workspace. See the documentation

Add Rows To Push Dataset

Append rows to a table in a Power BI Push Dataset (streaming / realtime data). Only works for datasets created via the REST API with defaultMode: Push — these datasets expose addRowsAPIEnabled: true on the object returned by **List Datasets**. Use **List Datasets** first to resolve a dataset name → datasetId and inspect its tables for the exact tableName (case-sensitive). Pass workspaceId (from **List Workspaces**) or workspaceName to target a specific workspace, or omit both for My workspace. Rows must match the table's column schema. rows accepts either a JSON array ([{...}, {...}]) or a JSON-stringified array. Each row is an object of columnName → value. Common mistakes: (1) case mismatch on tableName returns 404 — copy the exact string from the dataset's tables array. (2) Sending values that don't match the declared column data type returns RequestedResourceNotFound or DMTS_DatasourceHasNoCredentialsError. Push-dataset rows have no individual IDs and cannot be updated or deleted — only appended or bulk-cleared. See the documentation

Cancel Dataset Refresh

Cancels a refresh operation for a specified dataset in Power BI. See the documentation

Create Dataset

Creates a new Push Dataset in Power BI. See the documentation

Execute DAX Query

Execute a DAX (Data Analysis Expressions) query against a Power BI dataset (semantic model). This is the primary analytics tool — use it to answer questions about values, aggregates, or filtered rows in a dataset. Use **List Datasets** first to resolve a dataset name → datasetId. The query must be a single valid DAX expression starting with EVALUATE. **Table discovery (standard datasets):** For datasets published from Power BI Desktop, the REST GET /datasets/{id}/tables endpoint is scoped to push datasets only and will not list tables. Use EVALUATE INFO.TABLES() instead — it returns every table name in the semantic model. Typical agent flow: **List Workspaces** → **List Datasets** → **Execute DAX Query** (EVALUATE INFO.TABLES()) → **Execute DAX Query** (EVALUATE 'TableName'). Common patterns: • Discover all tables — EVALUATE INFO.TABLES() (use this before querying an unknown dataset) • List all rows of a table — EVALUATE 'Species' • Filter — EVALUATE FILTER('Species', 'Species'[dietType] = "Carnivore") • Top N by column — EVALUATE TOPN(5, 'Species', 'Species'[weightKg], DESC) • Aggregate single value — EVALUATE ROW("Total", SUMX('Species', 'Species'[weightKg])) • Peek at a table's columns — EVALUATE TOPN(0, 'Species') (returns an empty rowset with column names in the response). Limits: max 100,000 rows or 1,000,000 values per query, and DEFINE/multiple-statement queries are not supported via REST. The tenant must have 'Dataset Execute Queries REST API' enabled (admin setting) or the call returns 401/403. Pass workspaceId (from **List Workspaces**) or workspaceName to target a specific workspace, or omit both for My workspace. See the documentation

Export Report

Export a Power BI report to a file format such as PDF, PPTX, or PNG. Requires a report ID (use **List Reports** to find it) and defaults to PDF if no format is given. Pass workspaceId (from **List Workspaces**) or workspaceName to target a specific workspace, or omit both for My workspace. Supported format values depend on the report type: Power BI reports support PDF, PPTX, PNG. Paginated reports additionally support CSV, XLSX, DOCX, XML, MHTML. This API is **Premium-only**: requires the workspace to be backed by Premium capacity, Premium Per User, or Embedded capacity. On shared (free) capacity it returns FixedCapacityLimitExceeded / 403. The export is asynchronous — this tool starts the export, then polls until the job reaches Succeeded or Failed (or pollTimeoutSeconds elapses), then downloads the file and returns it as base64 along with the job metadata. PNG exports only work for single-page reports. For PPTX/PDF, pass pages (array of page names, e.g., ["ReportSection", "ReportSection1"]) to limit the export. See the documentation

Get Dataset Refresh

Triggers a refresh operation for a specified Power BI dataset. See the documentation

Get Refresh History

Get the refresh history for a Power BI dataset. Use **List Datasets** first to resolve a dataset name → datasetId. Pass workspaceId (from **List Workspaces**) or workspaceName to scope to a specific workspace, or omit both for My workspace. Each entry includes requestId, refreshType (OnDemand, Scheduled, ViaApi, etc.), startTime, endTime, status (Completed, Failed, Disabled, Cancelled, Unknown — Unknown means still in progress), and serviceExceptionJson on failures. See the documentation

Get Report by id

Retrieve metadata for a single Power BI report by ID. Uses My workspace by default; set Workspace (Group) ID for a specific workspace. See the documentation

Get Reports

Get reports from a Power BI workspace. See the documentation

List Dashboards

List Power BI dashboards in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from **List Workspaces**) OR workspaceName to scope to a specific workspace. Each dashboard includes id, displayName, isReadOnly, webUrl, and embedUrl. Note: dashboards cannot be created via the REST API — they are built interactively in the Power BI service. See the documentation

List Datasets

List Power BI datasets (semantic models) in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from **List Workspaces**) OR workspaceName to scope to a specific workspace. Each dataset includes id, name, webUrl, addRowsAPIEnabled (true for Push Datasets), isRefreshable, and defaultMode (Push, Streaming, PushStreaming, AsOnPrem, AsAzure). Use this tool to resolve a dataset name → ID before calling **Refresh Dataset**, **Execute DAX Query**, **Get Refresh History**, or **Add Rows To Push Dataset**. For push-dataset row inserts, call the dataset's GET tables endpoint (not exposed as a separate tool) by inspecting the dataset's name → tables are defined at dataset creation; the table name is the string configured at creation time (e.g., Species). See the documentation

List Reports

List Power BI reports in a workspace. Defaults to the authenticated user's personal My workspace when no workspace is specified. Pass workspaceId (preferred, from **List Workspaces**) OR workspaceName to scope to a specific workspace — the tool resolves the name to an ID server-side. Each report includes id, name, webUrl, embedUrl, datasetId, and reportType (PowerBIReport or PaginatedReport). Note: reports cannot be created via the REST API — they are published from Power BI Desktop. See the documentation

List Workspaces

List the Power BI workspaces (groups) the authenticated user can access. Use this tool first whenever the user refers to a workspace by name — it returns the id you need to pass as workspaceId to other tools. Power BI has no /me endpoint, so the set of accessible workspaces is the user's primary context (the 'who am I' signal for this app). Every item in the response includes id, name, isReadOnly, isOnDedicatedCapacity, and type. Note: when a user says 'my workspace' without a name, they may mean personal My workspace (implicit — pass no workspaceId to other tools) OR a specific named workspace — ask only if ambiguous. See the documentation

Refresh Dataset

Trigger a refresh of a Power BI dataset. Returns 202 Accepted on success; the request ID is available in the Location response header (last path segment) and x-ms-request-id header — use **Get Refresh History** to check status. Use **List Datasets** first to resolve a dataset name → datasetId. Pass workspaceId (from **List Workspaces**) or workspaceName to target a specific workspace, or omit both for My workspace. notifyOption controls email notifications on refresh outcome: NoNotification (default), MailOnCompletion, or MailOnFailure. Power BI Pro licenses allow up to 8 scheduled refreshes per day; Premium allows 48. Note: Push datasets accept this endpoint but the refresh is metadata-only (tile refresh), not a data refresh — no cancellable history entry is produced. See the documentation

Integration Features

22 documented WooCommerce actions
15 documented Microsoft Power BI actions
Plain-English agent instructions
Daily, weekday or weekly schedule, or run on demand
Execution monitoring
A supported Microsoft Power BI to WooCommerce direction

Capability Examples

WooCommerce trigger → Microsoft Power BI action

Catalog example
WooCommerceWooCommerce

New Coupon Event (Instant)

Microsoft Power BIMicrosoft Power BI

Add Rows to Dataset Table

Microsoft Power BI trigger → WooCommerce action

Reverse direction
Microsoft Power BIMicrosoft Power BI

Dataset Refresh Completed

WooCommerceWooCommerce

Add Order Note

How It Works

1

Connect Apps

Authenticate your WooCommerce and Microsoft Power BI accounts

2

Describe the Job

Say what to read from WooCommerce and what to do in Microsoft Power BI

3

Choose an Action

Select the documented Microsoft Power BI operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Scheduled or On-demand Runs

Runs daily, on weekdays or weekly at a set time, or when you click Run. It does not fire on live WooCommerce events yet.

Automated Actions

Use 15 documented Microsoft Power BI actions each time the agent runs.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Describe the job in plain English. The agent picks theWooCommerce and Microsoft Power BI actions it needs.

Your Own Accounts

You connect your own WooCommerce and Microsoft Power BI accounts. App connections need a paid plan.

Execution Review

Test the workflow and review provider responses before relying on it in production.

Microsoft Power BI logoWooCommerce logo

Reverse Integration Available

Also connect Microsoft Power BI to WooCommerce for bidirectional automation

View Integration
WooCommerce logo

All WooCommerce Integrations

Explore all available WooCommerce connections

View All Integrations
Microsoft Power BI logo

All Microsoft Power BI Integrations

Explore all available Microsoft Power BI connections

View All Integrations

Ready to Connect WooCommerce & Microsoft Power BI?

Build this agent in Mazaal AI and test it on your ownWooCommerce and Microsoft Power BI data.

Start building

Rather not build it yourself? We set up one WooCommerce to Microsoft Power BI agent on your accounts for A$490: a 30-minute call, a test on your real data, and 14 days of fixes. Plan billed separately. Email Enod