Offer

3 months of free support on every e-commerce package

See Details
GROWTH

Setting Up an E-Commerce Dashboard with Power BI: A Step-by-Step Guide

How do you build an e-commerce dashboard with Power BI? A step-by-step guide from connecting Shopify, WooCommerce and GA4 to DAX formulas.

GROWTH 23 September 2026 6 min read Toserof Tech.
Contents

Setting up an e-commerce dashboard with Power BI lets you track your sales data in real time and in visual form. Power BI is a powerful tool for turning raw data from Shopify, WooCommerce or Google Analytics 4 into meaningful insights. In this guide we cover every step of setting up Power BI from scratch and taking your e-commerce data into a professional dashboard.

Power BI Desktop vs Power BI Service: Which Should You Use?

The Power BI ecosystem consists of two main components: Power BI Desktop, which runs on the desktop, and the cloud-based Power BI Service. Desktop is used to develop reports and data models; it is free and runs on Windows. Service is used to publish and share reports and to set up automatic refresh; it requires a Power BI Pro or Premium licence. The recommended workflow for e-commerce teams is as follows: develop the data model in Desktop, publish the report to Service, assign permissions to team members and schedule automatic refresh. That way everyone always has access to up-to-date data.

  • Power BI Desktop: The report development environment; data connections, modelling and visualisation are all done with this tool. It is a free download and requires no licence.
  • Power BI Service: The cloud platform for publishing, sharing and automatic refresh; following the price increase on 1 April 2025, the Pro licence costs 14 USD per user per month on annual billing (as of October 2026).
  • Power BI Mobile: Provides mobile access to reports through the iOS and Android app; a separate layout can be created for the mobile view.

Data Connections: Connecting to E-Commerce Sources

Power BI's value comes from its ability to combine different data sources in a single model. The most common data sources for an e-commerce dashboard are Shopify, WooCommerce, Google Analytics 4 and Excel/Google Sheets.

Connecting to Shopify

There are two methods for connecting Power BI to Shopify. The first is to set up a REST API connection to the Shopify Admin API through Power Query; this method requires technical knowledge but offers the most flexibility. The second is to use Shopify's Power BI AppSource app; the connection can be made in a few minutes with the store URL and an API key. Once the connection is established, tables containing orders, products, customers and inventory are loaded automatically.

Connecting to WooCommerce and GA4

For WooCommerce, a REST API or a direct MySQL connection can be used. The MySQL method pulls data faster but requires database access permission. To pull Google Analytics 4 data into Power BI, you can use a Google Sheets intermediate layer, the BigQuery connector or the GA4 Connector (AppSource). If GA4's BigQuery export feature is enabled, Power BI's BigQuery connector offers the most stable and scalable solution. If you still use Excel or Google Sheets-based reporting, you can move the files to OneDrive and achieve automatic synchronisation with Power BI.

Building the Data Model and Relationships

The foundation of a strong Power BI dashboard is a correctly built data model. For e-commerce, the standard star schema is used: the Customers, Products, Dates and Channels dimension tables are connected to the central Orders fact table. Without correct relationships (1-to-many) between the tables, DAX calculations produce faulty results. In Power BI Desktop's Model view you can define relationships by drag and drop. Do not skip creating a date table; a separate Calendar table is essential for time-based analyses (YTD, MoM, WoW).

Core DAX Formulas: Templates for E-Commerce

DAX (Data Analysis Expressions) is Power BI's calculation language. The core DAX measures commonly used in an e-commerce dashboard are listed below. These formulas can be copied directly and adapted to your data model.

  • Total Revenue: SUMX(Orders, Orders[Quantity] * Orders[UnitPrice]) calculates total revenue at order-line level.
  • AOV (Average Order Value): The formula DIVIDE([Total Revenue], DISTINCTCOUNT(Orders[OrderID])) gives the average order value.
  • Conversion Rate: DIVIDE([Total Orders], [Total Sessions]) calculates the ratio of orders per session; it works when combined with GA4 data.
  • MoM Growth: DIVIDE([Current Month Revenue] - [Previous Month Revenue], [Previous Month Revenue]) displays the monthly growth percentage.
  • Customer Retention Rate: A DAX measure that tracks the proportion of customers in a given cohort who buy again in a later period; the CALCULATE and FILTER functions are used together.

Sales Performance Report and Customer Segmentation Visuals

When designing an e-commerce dashboard, pay attention to the visual hierarchy. KPI cards (total revenue, number of orders, AOV, conversion rate) should sit at the top, time-series charts (monthly revenue trend, weekly order count) in the middle, and detail tables (product performance, revenue by channel) at the bottom. For customer segmentation, you can visualise RFM (Recency, Frequency, Monetary) segments using scatter chart or tree map visuals. Add slicers to allow instant filtering by date range, category and channel.

Sharing, Permissions and Automatic Refresh

After publishing the report to Power BI Service, create a workspace and invite team members with the viewer, contributor or admin role. To protect sensitive data, you can use row-level security (RLS) to ensure each user sees only the relevant data. A Gateway setup is required for automatic refresh; on-premise data sources need an On-Premises Data Gateway, while cloud sources do not need a gateway. For API sources such as Shopify or WooCommerce, refresh can run up to 8 times a day. As an alternative, Looker Studio (formerly Google Data Studio) is free and offers deeper integration with the Google ecosystem; however, Power BI is more powerful for complex data modelling and DAX calculations.

Frequently Asked Questions

What is the difference between a Power BI dashboard and a Power BI report?

In Power BI, a report is a multi-page workbook; each page can cover a different analysis topic. A dashboard, on the other hand, is a summary screen on which visuals selected from different reports are pinned to a single page. For e-commerce, a dashboard is recommended for operational monitoring and a report for in-depth analysis.

How often can Shopify data be refreshed in Power BI?

With a Power BI Pro licence, refresh can run at most 8 times a day, and with a Premium licence it can run hourly. For real-time data needs, Power BI's streaming dataset feature or an Azure Stream Analytics integration can be considered; however, these scenarios are not necessary for the vast majority of e-commerce businesses.

How can I bring GA4 data into Power BI?

The most stable method is to activate GA4's BigQuery integration and use Power BI's BigQuery connector. The BigQuery free tier offers 1 TB of query capacity per month; this is usually sufficient for mid-sized e-commerce sites. For a simpler start, you can export GA4 data to Google Sheets and connect it to Power BI.

When should Looker Studio be preferred over Power BI?

If you mainly use the Google ecosystem (GA4, Google Ads, Google Sheets) and need relatively simple reports, Looker Studio is a free and fast alternative. However, when you need to combine multiple data sources and apply complex business rules, Power BI offers a far more powerful solution.

Conclusion

An e-commerce dashboard built with Power BI, when set up correctly, is a powerful decision-support tool that lets you monitor your sales, customer and marketing data on a single screen. By planning the data model, DAX measures and visual design stages carefully, you can create a structure that makes both real-time monitoring and in-depth analysis possible. Get in touch with Toserof Tech. for analytics and growth consultancy.

Share