Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically change the instance name of google bigquery dataset in power BI

How to use the same queries as many times with dynamic changing of dataset names ie dataset names will be passed as a parameter to replace the from statement.

How can I use a parameter to replace the bigquery from statement ‘projectname.schemaname’?

example: 

 

SELECT * FROM `bigquery-public-data.usa_names.usa_1910_2013`

has to be changed to

SELECT * FROM `bigquery-public-data1.usa_names1.usa_1910_2013`

No Replies