External connection (Power BI Data)

I saw many options but must of them are not Reliable or will use a lot of WU’s. The best option is (1. Direct database access), but we have this option only with Bubble Enterprise PLAN.

1. Direct database access (PostgreSQL) Enterprise PLAN
2. SQL Database Connector (send to external DB)
3. API Connector (internal/Json/paginated)
4. Zapier (send to external DB)
The App will have a huge historical data, data are changed daily, Power BI data with 30min max delay.

I’m planning use Option 3, and try to update All Data older than today once a day + each 30min get today’s Bubble changes.
Does someone did a similar strategy above? Or is there other best option?

Thanks!