What is the most straightforward way to get data from Claw into Power BI?

Everyone says "use the official Claw connector." I've looked at it. It's a black box that requires full admin rights and phoning home to Claw's servers.

I need a method that:
* Doesn't require another runtime dependency.
* Can be verified and secured independently.
* Respects data sovereignty clauses in our contract.

The vendor documentation only lists the "certified" path. What are the actual technical options? I'm considering:
* Direct API calls from Power Query, but their API auth is convoluted.
* A simple middleware container to transform and relay.
* Export to flat file from Claw, then ingest.

What is the simplest, most auditable process you've used in production? Specifics on auth handling and error logging are key. No marketing speak.