parameter syntax for teradata sql to restrict data at the dataset - Power BI report builder

[madhaviml]

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

[amitchandak]

@madhaviml , You should always select it from the expression builder

it should be like

WHERE column1 IN (@parameter_name)

refer, if these can help

https://www.youtube.com/watch?v=EZifdFfjTNg

https://www.youtube.com/watch?v=XA5twJ2wLd0