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?

It would be great to have it

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

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?

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

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.