Which Looker Studio reports are linked to BigQuery and refresh daily?

Hi Team, I’m looking for a way to identify reports in Looker Studio (formerly Data Studio) that:

  • Use BigQuery as a data source, and

  • Are set to refresh automatically every 12 or 24 hours directly from the Looker Studio UI

Ideally, I’d like to generate a list of all such reports so we can audit whether they are actively in use. If not, we plan to remove them.

Thanks in advance!

Best regards,
Ankit Sharma