AEM Data Connect to Power BI or other tools

I’m exploring whether AEM data can be connected directly to Power BI for reporting and visualization.

Our initial thought is to present the data in a Power BI dashboard, as that would be more digestible and useful than sharing raw data exports. I recall a similar question being asked several years ago (around 10 years back), and at the time the options were fairly limited.

Has anyone implemented this more recently?

• Is there now a supported or practical way to connect AEM data to Power BI (e.g., via APIs, connectors, or intermediate data stores)?

• Any lessons learned or recommended approaches?