Skip to main content
Microsoft Idea

Power BI

Needs Votes

Integrate Magento as data source

Vote (83) Share
Steffen's profile image

Steffen on 30 Mar 2015 19:51:31

Magento as a new datasource would be a great deal for many eCommerce companies as we are. Especially combined with google analytics & ERP data you´d have the whole picture.

Regards

Steffen

Comments (6)
Steffen's profile image Profile Picture

Power BI User on 05 Jul 2020 23:50:51

RE: Integrate Magento as data source

This would be great! The only way I can get Magento currently is on PBI desktop as a REST API and then push it to web manually. However, for security reasons, it cannot auto-refresh from my desktop which causes a lot of handholding.

Steffen's profile image Profile Picture

Kyrylo Kostiukov on 05 Jul 2020 22:57:13

RE: Integrate Magento as data source

You can use Magento Extension called Power BI Integration. It will deliver Magento Reporting data to Power BI Service on a regular schedule, https://www.bimproject.net/en/products/extensions-for-magento/power-bi-integration.html

Steffen's profile image Profile Picture

Noemie on 05 Jul 2020 22:57:07

RE: Integrate Magento as data source

That would indeed be awesome to cross the data from magento about the consumers and the sales reports. Did anybody find a way to do it?

Steffen's profile image Profile Picture

Guido Leenders on 05 Jul 2020 22:37:48

RE: Integrate Magento as data source

Hello Steffen do you mean Magento by direct database access, version 1.9 api or the new version 2.0 api?

Steffen's profile image Profile Picture

Phylipe Schad on 05 Jul 2020 22:29:26

RE: Integrate Magento as data source

It would be great to have it

Steffen's profile image Profile Picture

Monir on 05 Jul 2020 22:17:26

RE: Integrate Magento as data source

Yep, I was looking a way to learn that. Anyone have any ideas, how to perform CE ecommerce data analysis?