Connecting to MAGENTO (eCommerce platform)

[erezbenmoshe]

Hello,

Has anybody tried to connect to https://magento.com/?  If anyone did, I would appreciate some reference.

Thanks

[Syndicate_Admin]

I know that this issue has long been resolved, but you may be interested in this service. For connecting Power BI to Magento, I recommend checking out the InsightsReady extension available at https://insightsready.com. This tool specifically facilitates the integration of Magento with Power BI, making data analysis and reporting much more streamlined. It's worth exploring for your needs! I hope you find this useful)

[alexkaranda]

just in case if somebody looking for ready and go solution

Free Power Bi APP for Magento. 

Doesn't require any extra extensions!

https://appsource.microsoft.com/en-us/product/power-bi/decimadigital.magento_powerbi

[zdjfsk]

One can find help from Magento integration services.

[Harry33]

You can connect Magento and Power Bi via Skyvia — the no-coding integration solution. This integration isn't performed directly — Skyvia provides it through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.

[kost]

For Magento there is an extension that integrates Magento store with Power BI: https://www.bimproject.net/en/products/extensions-for-magento/power-bi-integration.html

The integration is done with REST APIs and delivers data directly to Power BI Service. 

Another option is usage of OData API, which is also provided by Power BI Sales Cube extension for Magento:

https://www.bimproject.net/en/power-bi-sales-cube-package-for-magento.html

[Greg_Deckler · Accepted solution]

I have not but I would assume that you would want to use the API: https://www.programmableweb.com/api/magento

[erezbenmoshe]

This is very helpful.

Is there any tutorial specificially about how to use this API from PB? 

I am also looking for examples.

Thanks

[Winedirect]

Hi Eresbenmoshe

Did you every get this working?  I am trying to figure it out myself at the moment.

Mark B

[kost]

I already did try this approach with connecting to Magento REST APIs. It takes significant efforts to get table by table being connected and data being extracted. It may put lot of presure on Magento (Adobe Commerce) server since API calls are not optimized for extraction of the whole history of data.

The best way to integrate Magento or Adobe Commerce with Power BI is to use Power BI Sales Cube extension from BIM. This solution delivers optimal data model into Power BI and keeps it updated by sending delta of the data. It is also very performant and can handle large datasets without taking performance of the system. It just that first load takes longer and every consequent data update happens in seconds.

As part of this extensions users may also add custom tables created based on Magento internal REST API endpoints, just to extend the core model. Such tables are taking longer to update and require manual data modeling, so they are used more to extend the model and not to replate it completelly.

[erezbenmoshe]

Hi, 

No, I didn't.  If you find a way, I would love to hear.

Thanks,

Erez