Integrate Magento as data source

[SGenz]

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

[monir1]

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

[phylipe]

It would be great to have it

[guido_leenders]

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

[noemiecp]

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?

[kirill533]

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

[audreyf1]

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.