Forum Discussion
Anonymous
6 years agoNot applicable
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