Powered by Adobe Commerce 2.4.3-p2


Power BI Sales Cube Lite

This is an Integration with a Third Party Service. Other charges and fees may be required to use this extension on your Store


Back to top

Power BI is a cloud-based business analytics service from Microsoft that allows you to have a single view on your most critical business data at any time, from any place. With Power BI account you are able to create, view and share your personal dashboards and reports with other Power BI users, access your dashboards on mobile devices or publish them to the web. 

The Power BI Sales Cube Lite extension includes a fully functional Business Intelligence solution with data preparation and incremental data delivery to Power BI Service.

The extension will automatically process and prepare sales data for analytics, and it will deliver this data to Power BI Service. It will automatically update the data with recent orders by configured schedule. Users of Power BI will have access to a sales dataset that includes a comprehensive data model with different measures and dimensions across the sales process, nicely linked together in the most optimized format for Power BI Service.

Once your data will be delivered to Power BI Service, you can:

  • Create your own reports with a simple drag and drop user interface.
  • Access your Power BI reports on Web and Mobile App.
  • Connect to your data from Power BI Desktop and extend the data model with your own calculated measures written as DAX (Data Analysis Expressions).
  • Share your reports, add bookmarks, set up alerts and many other features that continuously improve with new releases of Power BI.


Account & Pricing

Power BI Sales Cube extension is integrated with Azure Active Directory (Azure AD) to provide secure sign-in and authorization for your Magento store. Before you start using Power BI Sales Cube you need:

All users, who will be using Power BI from your Magento store will have to be added to your Azure Active Directory tenant.

The extension uses a Client ID to identify itself to Azure AD. You also need a client secret key. Please, refer to Microsoft Power BI documentation for the information on how to set up an Azure AD environment for the Power BI app in and get authentication security token (client secret key). Obtained client ID and client secret key might be provided to the Power BI extension on Magento configuration page.

You can use Power BI service for free or buy Power BI Pro for $9.99 / USER / MONTH. Alternatively, you may purchase capacity based service with Power BI Premium or Power BI Embedded package. See pricing and features for more details. All features described below relate to a free service plan if not stated explicitly.

Additionally, you will be required to register on a website of the extension developer to get the license activation code for your license. 


Key Features

  • Highly efficient incremental Data Extraction from Magento Platform
  • Prepare and load sales data in a form, optimized for Q&A and Ad-Hoc Interactive Reports
  • The fully automated process of data delivery and reports actualization
  • High level of data quality ensured with thorough automated and manual testing
  • Business-friendly, well-documented data model allowing business-oriented users to build reports and dashboards without any technical knowledge
  • Data includes relationships between websites / stores / products / categories / orders / order items / invoices / customers that allow to cross-filter / drill-down to the level of a single order line
  • Support for Power BI workspaces for easy collaboration with your colleagues
  • Possibility to use a separate database for Analytical data processing (Mini DWH / Data Mart)
  • No extra software required. All communication is done via the APIs directly with Power BI Service


Lite vs Full

Lite version includes the most valuable part of Power BI integration: the Sales Cube dataset. The difference of Power BI Sales Cube Lite compared to Power BI Sales Cube extension is that it does not include report management tools, embedding functionality and out of the box sample reports.


Use Cases

  • Provide Mobile access to Magento sales statistics to your team and stakeholders
  • Use interactive reports to analyze sales performance and to understand what are the factors that influence the performance
  • Easily create any custom reports based on sales data of any complexity with custom calculated measures
  • Provide access to ready to use, cost-efficient BI solution for your employees to drive a data-driven culture
  • Do not miss market opportunities by letting your Sales and Marketing teams have an easy way of getting insights from your data
  • Set up measurable goals as your objectives and provide easy ways of monitoring your success
  • Save time and costs on development and integration with BI tools by using ready to use full-stack BI solution provided with high-quality support


Sample Reports

The reports are created on top of the Sales Cube dataset and demonstrate reports that could be created in Power BI once the Magento data will be delivered to Power BI Service in form of Sales Cube. The sample reports itself are not provided with Lite version of the extension.

If you wish to recreate one of the presented sample reports, you may contact our support and we either provide you with the desired report or we will help you to create one.

  1. Sales Forecasting
  2. Monthly performance report
  3. Related products
  4. Repeated orders
  5. Average order value
  6. Data actualization status
  7. Today's performance
  8. Latest 7 days performance
  9. Orders by state
  10. Average price analysis
  11. Product price change
  12. Sales rule performance analysis
  13. Orders overview
  14. Sales overview
  15. Year to year comparison
  16. Top products
  17. Product attributes analysis
  18. Payments analysis
  19. Workflow time analysis
  20. Sales by location
  21. Age and order behavior analysis
  22. Advanced product search
  23. Products ABC analysis
  24. Customers ABC analysis
  25. Customer-based basket analysis



Our support covers the data quality. Together with our SLA, we provide Data Dictionary with a description of data tables, columns, and calculated measures. If something does not behave as it is described, we will investigate the issue and provide you with a solution.

Our goal is to make sure that our solution will fit your particular needs and that you will take maximum benefits from insights based on your data. Read more about support conditions in our Service Level Agreement.

With our support, you are not required to have dedicated in-house ETL / BI professionals responsible for maintaining the process of data preparation and delivery. We advise you on how you can achieve your goals with respect to reporting based on your Magento sales data. 

Technical Specifications

Back to top

Seller profile

Kyrylo Kostiukov

Seller contact



Power BI Service

Current Version


Adobe Commerce platform compatibility

Open Source (CE): 2.3 (current), 2.4 (current)

Commerce on prem (EE): 2.3 (current), 2.4 (current)

Commerce on Cloud (ECE): 2.3 (current), 2.4 (current)


Stable Build


11 August, 2021


Extensions, Reporting & Analytics

Quality Report

Back to top

Installation & Varnish Tests


Coding Standard


Plagiarism Check


Malware Check


Marketing Review


Manual Testing


All tests were conducted on the latest versions of Adobe Commerce that existed for the compatible release lines at the moment of the extension submission. Latest versions of all other software were used, as applicable.

Release Notes

Back to top


  • Compatible with Open Source (CE) : 2.3 2.4
  • Compatible with Commerce on prem (EE) : 2.3 2.4
  • Compatible with Commerce on Cloud (ECE) : 2.3 2.4
  • Stability: Stable Build
  • Description:

    Bug-fixing and performance improvements.


  • Compatible with Open Source (CE) : 2.3 2.4
  • Compatible with Commerce on prem (EE) : 2.3 2.4
  • Compatible with Commerce on Cloud (ECE) : 2.3 2.4
  • Stability: Stable Build
  • Description:

    Support for latest Magento versions (up to 2.4.2). Bug-fixing. Some minor enhancements and better support for customizations.


  • Compatible with Open Source (CE) : 2.3
  • Stability: Stable Build
  • Description:

    Adding missing dependency module


Back to top

The best place to start if you need help with a specific extension is to contact the developer. All Adobe Commerce developers have both a contact email and a support email listed.

Contact Vendor

Q & A

Back to top


Back to top