Forum Discussion
power query | parameter query to filter data a predefined list from google bigquery database
hi, i get my data for period beginning 01 January 2015 from google bigquery as follows: Source = Value.NativeQuery(GoogleBigQuery.Database() {[Name="abc-stock"]}[Data], "select * from abc-sto...
Dear all,
It finaly worked !
The Parameter needs to be declared as “&ParameterName&”
If this is in a where clause set as below xxxx where ‘“&ParameterName&”’
Source = Value.NativeQuery(
GoogleBigQuery.Database([BillingProject = BQ_Source]){[Name = BQ_Source]}[Data],
"SELECT
*
FROM dwh.Table AS sa
where 1=1
and sa.Country= '"&CountrySelection&"'"
Then you need a parameter name CountrySelection where you set your string
,
null,
[EnableFolding = true]
)
thank you for your help