How to Integrate Microsoft Power BI with Magento 2 store?

[lambo32qgm099c]

Can we create reports for orders and invoices of the Magento 2 store at the Power BI console and then import them into the Magento 2 store for visualization?

[NishadBhan · Accepted solution]

Yes, you can make use of the Magento 2 Power BI Connector that allows you to create reports for orders and invoices at the Power BI console and then import them into your Magento 2 store.

Using this extension, you as an admin can - 

• Connect your Magento 2 store with the business intelligence tool Microsoft Power Bi.
• Create and export datasets of sales orders and sales invoice tables.
• Import Power Bi reports and dashboards into Magento 2 store.
• Visualize PowerBi reports and dashboard from Magento 2 backend.
• Create a dashboard in Power Bi for your workspace and view it in Magento 2 backend.

Hope this helps!