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

[ankitdpsharma]

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