Forum Discussion
parameter syntax for teradata sql to restrict data at the dataset - Power BI report builder
Hi,
I am trying to build a paginated report with Teradata SQL
Select column1 from table1
where column1 in @Nameof the parameter
How can I send the parameter value to Where cluase directly?
I tried different syntax or expressions ex. below
where column1 in @Nameof the parameter
where column1 in '@Nameof the parameter'
where column1 in ['@Nameof the parameter']
Thanks in advance
1 Reply
madhaviml , You should always select it from the expression builder
it should be like
WHERE column1 IN (@parameter_name)
refer, if these can help
