Integration with Microsoft Power BI Rest API. Monitor your most critical reporting data in Web or Mobile app.
Other Extensions by Kyrylo Kostiukov
OverviewBack 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.
You can use Power BI for free or buy Power BI Pro for $9.99 / USER / MONTH. See pricing and features. All features described below relate to free service plan if not stated explicitly.
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. See following resources to learn how to register and authenticate a Power BI extension: Register a client app, Authenticate a Power BI client app, Register a web app and Authenticate a Power BI web app. Obtained Client ID and client secret key might be provided to the Power BI extension on Magento configuration page.
Such integration will allow to use 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 mobile app to access visual representation of the Magento Reporting data.
- Setup notifications to be notified about events that need immediate attention.
Power BI Reports and Dashboards
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 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 regular schedule or in Live mode to allow you updating the data within weekly, daily, hourly or even with several minutes intervals.
Flexible data configuration allows to send data only for the period you want to monitor: it could be latest days, weeks or months, previous day, YTD values or other desired configuration.
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.
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.
The workflow is quite simple. Once installed the extension will add 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 configuration of the export profile by setting dynamic date intervals and adding Power BI specific configurations such as Dataset and Table names. Next step would be to activate the export profile and publish the dataset.
To have 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.
Microsoft offers free accounts with 1 GB of storage limit and 10K rows/hour for streaming data. You may increase this limit with subscription for Power BI Pro account. Since the extension gives possibility to deliver only portions of data you need, you may stay within the limits of free account. Also, you may control the size of the data by taking aggregated reporting data. Since extension is using REST API to deliver data directly to Power BI service, limitation of data updates once per day does not apply.
Current version of the extension and Power BI API have several limitations, that should be taken into account:
- 75 max columns
- 75 max tables
- 10,000 max rows per table (this limit will increase in future releases of the extension)
- 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
Extension currently supports 19 reports for Magento 2. Full list of supported reports you may find in the Users Guide.
Release NotesBack to top
- Compatible with CE: 2.1
- Stability: Beta Build
First release of the Power BI Integration for Magento 2