OverviewBack to top
Power BI is a business analytics solution that lets you visualize your data and share insights across your organization, or embed them in your app or website. 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 Connector enables you to stream all your data from Magento 2 to Power BI. Add Magento to your main data sources and get the latest and fullest data for consistent business decisions. Business intelligence solutions help companies transform actual data into actionable insights. Our app makes your data landscape wider by adding Magento as a data source to your current Power BI tool.
- Power BI Connector is user-friendly, with customization options to fit your skill level and need.
- Power BI Connector supports a wide range of Magento data configuration to export any field you wish.
- Reliable Customer Support is available for your convenience.
You can have all your projects on a single view to drive timely decision-making and keep focus. Using Power BI, team members track activity and evaluate results to determine overall business outcomes.
Account & Pricing
The extension uses a Client ID to identify itself to Azure AD. Please, refer to Microsoft Power BI documentation for the information on how to set up an Azure AD environment for the Power BI app. Obtained client ID might be provided to the Power BI Connector extension on Magento 2 configuration page.
You can sign up for 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.
Export To Power BI Information
- Ordered Products
- Product Views
- Product Reviews
- Products In Cart
- Abandoned Carts
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. 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 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 SpecificationsBack to top
Magento platform compatibility
Open Source (CE): 2.3 (current), 2.4 (current)
26 January, 2021
Extensions, Reporting & Analytics
Quality ReportBack to top
All tests were conducted on the latest versions of Magento 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 NotesBack to top
- Compatible with Open Source (CE) : 2.3 2.4
- Stability: Stable Build
Improvements and optimizations for M2.4
- Compatible with Open Source (CE) : 2.3
- Stability: Stable Build
Initial extension release
SupportBack to top
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.Contact Vendor