Not sure if this is the correct forum for this. But please advise if you can.

We are trying to create a data mart in Oracle Database for Power BI reports. (Not In-built functionality Data marts of Power BI Since it has only Direct Query option).

All our Data Sources are in One Drive Excel. We want to migrate them to Oracle DB and set the refresh automated. And then from Oracle DB to PBI.

How do we Set up automated refresh from One Drive Excel to Oracle DBs? Shall We use any ETL tool for this?

Or any other option available? Please advise.

I am thinking of making Flow in Power Automate and get this done in automated way.

But please advise if there is a better way to do this.