https://community.fabric.microsoft.com/t5/Report-Server/Dynamically-change-the-instance-name-of-google-bigquery-dataset/m-p/1003156#M13657 <P>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.</P><P>How can I use a parameter to replace the bigquery from statement ‘projectname.schemaname’?</P><P>example:&nbsp;</P><P>&nbsp;</P><P>SELECT * FROM `bigquery-public-data.usa_names.usa_1910_2013`</P><P>has to be changed to</P><P>SELECT * FROM `bigquery-public-data1.usa_names1.usa_1910_2013`</P> Wed, 01 Apr 2020 16:41:34 GMT Anonymous 2020-04-01T16:41:34Z https://community.fabric.microsoft.com/t5/Report-Server/Dynamically-change-the-instance-name-of-google-bigquery-dataset/m-p/1003156#M13657 <P>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.</P><P>How can I use a parameter to replace the bigquery from statement ‘projectname.schemaname’?</P><P>example:&nbsp;</P><P>&nbsp;</P><P>SELECT * FROM `bigquery-public-data.usa_names.usa_1910_2013`</P><P>has to be changed to</P><P>SELECT * FROM `bigquery-public-data1.usa_names1.usa_1910_2013`</P> Wed, 01 Apr 2020 16:41:34 GMT https://community.fabric.microsoft.com/t5/Report-Server/Dynamically-change-the-instance-name-of-google-bigquery-dataset/m-p/1003156#M13657 Anonymous 2020-04-01T16:41:34Z