Connect Magento to Power BI

Connect the Magento store in Catchr with its URL, Consumer Key, Consumer Secret, Access Token and Access Token Secret. In Catchr’s Power BI query builder, select order identifiers and sales amounts and preview a short extraction. Import the generated URL through Get data > Web in Power BI Desktop. Check the returned rows before building measures, keeping order-level totals versus repeating line items clear in the model.

The connector exposes orders and order items, including order IDs, statuses, store information, customer-group fields, totals, taxes, shipping, discounts, paid amounts, and refunds. Product-level fields include SKU, product type, prices, and quantities ordered, invoiced, shipped, cancelled, or refunded. Choose fields that match the stage of the sale you want to measure.

These describe different stages of the order lifecycle. An order can exist before it has been fully invoiced or paid, and later cancellations or refunds can change the amounts involved. Keep those totals as separate measures and align order status filters with your reporting goal rather than labeling every order total as collected revenue.

Magento exposes base-currency and order-currency fields, along with their currency codes and exchange-rate information. Choose one consistent basis for financial comparisons. If orders use several currencies, do not add their unconverted grand totals; group by currency or use a validated common-currency measure.

Yes. Order-item fields distinguish quantities ordered, invoiced, shipped, cancelled, and refunded, while order fields include refund totals. These can help identify changes in fulfillment and returns. Keep order-level and item-level amounts separate, and do not interpret an order’s current refund total as the amount refunded on its creation date.

Adding item details can repeat order-level values for each product row. Use distinct order IDs to count orders and the corresponding item totals for product analysis. Check product type and row structure for configurable or bundled products before summing quantities, so that related rows are not counted as separate customer orders.

Yes. Add Google Analytics 4 to compare store orders with tracked website activity. Validate transaction IDs and align store scope, currencies, and dates before joining purchase data. Magento records commerce operations, while GA4 depends on event tracking, so their order and revenue figures can differ.