PowerBI Bigquery Connector - External tables?

Dear team,

I have been trying to access in PowerBI a table that comes from Google Sheets and is currently stored in BigQuery. In other words, BigQuery sees it as an external table. However, it does not appear in PowerBI. I have learned from this source that:

"This is because the Power BI Google BigQuery Connector doesn’t support External BigQuery tables. It only supports the Native BigQuery tables. Since Test_data is an external table, it doesn’t get listed here."

The same source above also tells me that there is a workaround, that looks like the code below, and is implemented in BigQuery:

CREATE TABLE `project_name.dataset_name.Test_data_NEW`

AS SELECT * FROM `project_NAME.DATASET_NAME.TEST_DATA`

This workaround works.

However, I would like to know if there is a more elegant/straightforward solution that is not a workaround.

Thanks for your attention!

Best,

Francisco