Powered by Adobe Commerce 2.4.8

power_bi_logo_400x400_1_1_1_1.png

Power BI Integration

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

Trader Information

Back to top

Overview

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 free Power BI account you will be able to load up to 1 GB of data per user and use this data 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.

Power BI extension will deliver reporting data from your Magento store to Power BI Online service. Based on this data you can create interactive reporting and dashboards that will be available to you at any time. Data will be updated on a regular schedule, so you will always be able to see relevant data. Power BI extension allows you to configure different data to be delivered on a regular schedule or in Live mode to allow you updating the data within weekly, daily, hourly or even with several minutes intervals. 

 

Account & Pricing

Power BI 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 extension you need an Azure Active Directory tenant, an organizational user, and a Power BI service account. 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 for free or buy Power BI Pro for $9.99 / USER / MONTH. Alternatively, you may purchase capacity based service with Power BI Premium 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

  • Utilize free Power BI Service from Microsoft to bring new reporting capabilities for your online store without any coding needed.
  • Create interactive Power BI Reports based on Magento data focusing on your most important KPIs.
  • Automate data actualization of Power BI reports, so creating a custom report once will require no further efforts keeping it up to date.
  • Support for multiple data sources, including API, CSV, SQL and other customized tables, allowing for a variety of data extraction and import methods.

 

Table Profiles: where the data comes from

Power BI extension for Magento offers a range of Table Profiles to help users access and manage data from their Magento store to further create insightful reports. Here is a brief overview of each type of Table Profile available: 

  • API Table Profile enables the delivery of all available information all information, available within Magento REST APIs from Magento to Power BI, allowing for the creation of reports of varying complexity that can be used for business analysis and decision-making purposes.
  • CSV Table Profile allows users to merge Magento data with external data sources by importing data from CSV files into their Power BI reports, defining the format of the CSV file and specifying which data elements to import.
  • Date Time Hierarchy Table Profile allows users to create hierarchies based on date and time data, defining custom hierarchies based on year, quarter, month, week, and day intervals.
  • SQL Table Profile provides users with the capability to fetch  data from a store's database and define bespoke SQL queries, thereby enabling the extraction of specific data elements required for the development of reports and dashboards that cater to their unique needs. To ensure security, custom SQL queries must be defined in XML configuration files prior to their execution.
  • ETL Monitoring Table Profile allows users to track the status of Extract, Transform, and Load (ETL) jobs within their Magento store, monitoring ETL jobs in real-time and accessing detailed job logs to identify issues and troubleshoot problems.
  • Report Table Profile allows users to deliver data from Magento default reports such as sales, products, customers, etc., providing out-of-the-box ready-to-use reports to get started and inspiration to create their own reports.

 

Performance, Efficiency and Sales Cube package 

Our data extraction package for Magento offers a range of options to generate reports by leveraging the platform's capabilities. However, the effectiveness of data extraction relies on the implementation of data reading logic within Adobe Commerce / Magento. Moreover, manual configuration is essential to specify the data to be extracted and its relationships, while proficiency in data modeling may also be required to produce accurate reports.

Our support team is available to help with configuration as part of the license purchased. Please note that the performance of data extraction is limited by core Magento classes that may not always be optimized for data reading.

For a more comprehensive solution, we offer Sales Cube Package, an extended Power BI Integration package. Sales Cube features our own implementation of complete data extraction and preparation process, which employs various techniques to optimize performance and maximize efficiency. This efficiency helps to keep actual data in Power BI almost in real time while putting minimum overhead on Adobe Commerce / Magento system

Sales Cube is an out-of-the-box solution that adheres to best practices in data modeling, transforming data into a format suitable for reporting within Power BI. Although it is available at a higher price, Sales Cube offers a quicker start and includes all key sales data modeled to enable even BI analysts without Magento system knowledge to work with the data.

 

API Table Profiles: most flexible solution for getting the right data

With our Power BI extension, users can easily define API Table Profiles to access data from their Magento store and use that data to build custom reports and dashboards. The benefits of using API Table Profiles are the following: 

  • Seamless integration with Magento: Our extension leverages Magento's API to ensure reliable and secure access to your store data. 
  • Flexible data access: With API Table Profiles, users can define exactly what data they need to access from their store, including specific tables, fields, and other data elements.
  • Simplified reporting: By using API Table Profiles to access data from the Magento store, users can streamline the process of creating reports and reduce the risk of errors or data inconsistencies as they do not need to extract the data and transform it into a format that can be used by the reporting tool. 

Even though, you get lot of flexibility with our Table Profiles,  we recommend to utilize Sales Cube package to get the core sales data in the most efficient way while using Table Profiles to bring the data that is missing in the Sales Cube package. 

 

Workflow: how does it work

The workflow is quite simple. Once installed and configured, the extension will send data from Adobe Commerce / Magento store to Power BI cloud service from Microsoft via secure Power BI REST APIs. 

As result, you will have a semantic data model inside Power BI Service, ready to be used as a data source for Power BI report creation.

The semantic data model will update its data automatically, so you do not need to take care of it once it was setup.

Power BI is a very flexible and easy to use solution to create customized reports. With semantic data model you avoid complex steps of data preparation and can start creating your reports without much of technical knowledge. 

 

Limitations

There are some limitations are available in Power BI you might need to know about. Our solution automatically adjust the loading process to meet Power BI limitations. Power BI offers enough space to keep all history of your Adobe Commerce / Magento sales data. And it if gets too bit, the extension offers the means to limit the amout ot historical data.

Most important limitations related to Power BI are:

  • 1GB of data storage in Power BI free and 10GB in Power BI Pro version
  • 75 max columns per table
  • 75 max tables per dataset
  • 5,000,000 max rows per table
  • 1,000,000 rows added per hour per dataset

Technical Specifications

Back to top

Seller profile

Kirill Kostiukov

Seller contact

E-mail

Integrator

Power BI Service

Current Version

2.3.0

Adobe Commerce platform compatibility

Adobe Commerce (cloud): 2.4 (current), 2.3 (obsolete)

Adobe Commerce (on-prem): 2.4 (current), 2.3 (obsolete)

Magento Open Source: 2.4 (current), 2.1 (obsolete), 2.2 (obsolete), 2.3 (obsolete)

Type

Stable Build

Updated

23 August, 2024

Categories

Extensions, Reporting & Analytics

Quality Report

Back to top

Installation & Varnish Tests

Passed

Coding Standard

Passed

Plagiarism Check

Passed

Malware Check

Passed

Marketing Review

Passed

Manual Testing

Passed

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

2.3.0:

  • Compatible with Adobe Commerce (cloud) : 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.4
  • Compatible with Magento Open Source : 2.4
  • Stability: Stable Build
  • Description:

    Support for Magento 2.4.6 and php8.2. Bug fixes and improvements.

2.2.18:

  • Compatible with Adobe Commerce (cloud) : 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.4
  • Compatible with Magento Open Source : 2.4
  • Stability: Stable Build
  • Description:

    Support for Magento 2.4.6 and php8.2. Bug fixes and improvements.

2.2.17:

  • Compatible with Adobe Commerce (cloud) : 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.4
  • Compatible with Magento Open Source : 2.4
  • Stability: Stable Build
  • Description:

    Support for Magento 2.4.6 and php8.2. Bug fixes and improvements.

2.2.16:

  • Compatible with Adobe Commerce (cloud) : 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.4
  • Compatible with Magento Open Source : 2.4
  • Stability: Stable Build
  • Description:

    Support for Magento 2.4.4 and PHP8.1.

2.2.14:

  • Compatible with Adobe Commerce (cloud) : 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.4
  • Compatible with Magento Open Source : 2.4
  • Stability: Stable Build
  • Description:

    Support for Magento 2.4.4 and PHP8.1.

2.2.11:

  • Compatible with Adobe Commerce (cloud) : 2.3 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.3 2.4
  • Compatible with Magento Open Source : 2.1 2.2 2.3 2.4
  • Stability: Beta Build
  • Description:

    Added possibility to populate Power BI Tables from CSV files and from Magento API EndPoints.

2.2.8:

  • Compatible with Adobe Commerce (cloud) : 2.3 2.4
  • Compatible with Adobe Commerce (on-prem) : 2.3 2.4
  • Compatible with Magento Open Source : 2.1 2.2 2.3 2.4
  • Stability: Beta Build
  • Description:

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

2.1.5:

  • Compatible with Magento Open Source : 2.1 2.2 2.3
  • Stability: Beta Build
  • Description:

    Release with better handling of limitations of Power BI API. Multiple requests allow to add more data at one data actualization circle. Support for Magento 2.3.

2.1.1:

  • Compatible with Magento Open Source : 2.1 2.2
  • Stability: Beta Build
  • Description:

    Fix grid actions.

2.1.0:

  • Compatible with Magento Open Source : 2.1 2.2
  • Stability: Beta Build
  • Description:

    Add support for Magento 2.2.
    Version numbering changed: number 2 in front of the version number correspond to version of Magento.

1.0.6:

  • Compatible with Magento Open Source : 2.1
  • Stability: Beta Build
  • Description:

    First release of the Power BI Integration for Magento 2

Support

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

Reviews

Back to top