Recently added item(s)
You have no items in your shopping cart.
Integrate your Magento store with Power BI Service, 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.
The package delivers one of the most useful parts around out Power BI Integration solutions: Sales Cube - comprehensive sales data ready for analysis in Power BI.
Deliver all data related to sales in its best shape optimized for usage with Power BI. Business friendly data model provides easy way to analyze data without technical knowledge about Magento internals.
Keep your reports and dashboards up to date with recent data by configuring a schedule for automated data actualisation. Monitor the loading process with user friendly interface.
Deliver only latest orders' data without the need to do a costly and long-running full data reload. This allows to update data faster and more frequently.
Do not restrict yourself in your analysis. Our highly optimized solution will handle full history of orders that can fit into Power BI Service. Our scalable solution may also work with hardware resources dedicated only for analytical data processing.
The extension offers two ways of integration where each way helps to satisfy certain use cases. REST API dataset is more business friendly and easy to use. OData allows more advanced usage with custom data modeling.
Build with best practices of BI industry our solution is ready to satisfy all sorts of needs for any business. Our support will be there to guide you to the right ways of achieving your business goals with our solution.
Find more detailed information about how to use the extension in our documentation pages.
Or use PDF version of our User Guide:
With your Magento data being delivered to Power BI, you can stay informed about your key business activities. Keep overview over your business with Power BI and share regularly your business insights with your stakeholders and your team.
Use data delivered from Magento to create Interactive Reports and Dashboards in Power BI Service from Microsoft.
Access your reports and dashboards anytime with Power BI Mobile App
Setup alerts and get notified on your mobile phone or per email when you reach (or not reach) certain performance threshold.
Registration and usage of Azure Active Directory for setting up the Power BI API is free and you should be able to setup the integration without the need to purchase any services from Microsoft.
Once the data will be delivered to Power BI, you can use the delivered dataset to create reports and dashboards. You can access created dashboards with Power BI Online Service or using Power BI Mobile App.
We offer yearly and perpetual license. Each license is valid for one Magento installation. Term license includes continuous support, upgrades to latest Magento and Power BI releases, provides access to latest features. With perpetual license the support is limited to 1.5 years, with possibility to extend this period.
The Power BI Sales Cube is released in two different packages to meet certain business cases.
The most comprehensive package that on top of core integration with Power BI includes advanced data modeling part, forming a Sales Cube - extensive dataset with all data related to sales process. Instead of relying on core Magento reporting, Sales Cube includes alternative logic for analytical data preparation and forms a structure that is optimized for being used in Power BI.
Additionally, the package includes embedding functionality, sample ready to use reports and integration with usage of OData for more advanced use cases.
This package includes one the most advanced parts of our Power BI Integration: the Sales Cube. With Sales Cube users can get their data delivered to Power BI in its best shape. At the same time, Lite package does not include all of the extras that come with the full Sales Cube package.
Feel free to contact us if you have any questions.