Funnel Data source connection issue after owner accounts were deactivated

Hello everyone,

We are currently facing a major issue with our Looker Studio reports. The original creators of our reports and data sources (connected via Funnel) have left the company, and their email accounts have been desactivated.

Since then, many of our reports no longer work because the data sources are inaccessible.
At the moment, the only solution I’ve found is to:

  • Set myself as the new owner of each data source,

  • Then make the data reusable again.

However, we have around 300 Looker Studio reports, so doing this manually is far too time-consuming.

:backhand_index_pointing_right: My question:
Is there any way to transfer data source ownership in bulk (or automatically reconnect them to another account) ? for example through the Google Admin Console, a Looker Studio API, or another Google tool?