Copying a Report Using Extracted Data from BigQuery in Looker Studio

Hello, I have a question about copying reports created using extracted data from BigQuery in Looker Studio.

Background:
Currently, I am using Looker Studio connected to BigQuery and have set up a report as follows:

  • Connected the "monthly_summary" table in BigQuery to Looker Studio and created a data source named "monthly_summary."
  • Extracted data from the "monthly_summary" data source in Looker Studio and created an extracted data source named "ex_monthly_summary."
  • Created graphs in the report using the "ex_monthly_summary" extracted data source.

taiga_fukagawa_0-1737453793687.png

What I Want to Achieve:
When I try to copy this Looker Studio report, the "ex_monthly_summary" extracted data source is successfully transferred to the new report, as shown in the attached image. However, since the "monthly_summary" data source does not exist in the copied report, the graphs show errors.

taiga_fukagawa_1-1737453809433.png

Ideally, I would like to copy both "monthly_summary" and "ex_monthly_summary" data sources to the new report simultaneously. However, I have not been able to do so despite my attempts.

Is there an effective way to copy reports that use extracted data sources without causing errors?

1 0 147