How to dynamically select bigquery table as data source in a report?

I’m having a dataset in bigquery with multiple tables with the same structure (each for one customer).

I would like to create and embed a report with a dynamic source that sets the table used as source for the report.

All table names are in dataset X and have a similar name customer_name_report_data.

How can I do this, couldn’t find any help online.

1 1 399
1 REPLY 1

Did you find any solution for this? I have a similar requirement.