Powered by Adobe Commerce 2.4.6-p4

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:

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

  • The integration allows using Power BI Service to bring new functionality for the online store without any coding needed
  • Create interactive Power BI Reports and Dashboards based on Magento Reporting Data.
  • Use a mobile app to access a visual representation of the Magento Reporting data.
  • Setup notifications to be notified about events that need immediate attention.

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 Profiles: This type of Table Profile allows for the extraction of data from various functionalities within the Magento platform. Through the use of APIs, the API Table Profile enables the delivery of all available information from Magento to Power BI. It essentially serves as a mapping tool that aligns and formats the data fields and columns from Magento to match those in Power BI. By doing so, it facilitates the creation of reports of varying complexity that can be used for business analysis and decision-making purposes.
  • CSV Table Profiles: This type of Table Profile allows users to import data from CSV files into their Power BI reports. Users can define the format of the CSV file and specify which data elements to import. 
  • Report Table Profiles: will deliver data from Magento default reports such on sales, products, customers, etc.

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. 

 

Power BI Reports & Dashboards

Flexible data configuration allows you to send data only for the period you want to monitor: it could be the latest days, weeks or months, the previous day, YTD values or other desired configuration.

 

Mobile App

Access your data at any time with Power BI Mobile - Power BI app for Windows, iOS and Android. Optionally you will also be able to see your Power BI Reports and Dashboards in your Magento store.

 

Data Alerts

Set alerts to notify you when data in your dashboards changes beyond limits you set. Data alerts are fully synchronized across platforms; set and view data alerts in the Power BI mobile app for iPhone, Power BI mobile app for Windows and in the Power BI service. Power BI sends an alert to your notification center and, optionally, in an email. Each alert contains a direct link to your data.

 

Workflow

The workflow is quite simple. Once installed the extension will add the possibility to send data from reporting pages of the Magento store to Power BI extension. Triggering this action will create an export profile within the extension and will keep information about selected filters. On the extension's page, you may finish the configuration of the export profile by setting dynamic date intervals and adding Power BI specific configurations such as Dataset and Table names. The next step would be to activate the export profile and publish the dataset.

To have a well-organized process of dashboards and reports creation it is recommended to do some initial planning so that you will prepare all data you will need for your report at once.

 

Limitations

Microsoft offers free accounts with 1 GB of storage limit and 10K rows/hour for streaming data. You may increase this limit with a subscription for the Power BI Pro account. Since the extension gives the possibility to deliver only portions of the data you need, you may stay within the limits of a free account.

Also, you may control the size of the data by taking aggregated reporting data. Since the extension is using REST API to deliver data directly to Power BI service, the limitation of data updates once per day does not apply. The extension currently supports data loading from 13 Magento reports in Magento 2. Full list of supported reports you may find in the Users Guide. The current version of the extension and Power BI API have several limitations, that should be taken into account:

  • 75 max columns
  • 75 max tables
  • 1,000,000 max rows per table
  • 10,000 rows added per hour per dataset (with pro service plan: 1,000,000 rows added per hour per dataset)
  • 5 max pending POST rows requests per dataset
  • 120 POST rows requests per minute per dataset
  • 4,000 characters per value for string column in POST rows operation

Technical Specifications

Back to top

Seller profile

Kyrylo Kostiukov

Seller contact

E-mail

Integrator

Power BI Service

Current Version

2.2.18

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

13 July, 2023

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.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