Error en query "token RightParen" por favor ayuda

[Alexis_Sawyer]

Hola,

Tengo la siguiente consulta con el error " Se esperaba el token RightParen" en la coma marcada en rojo. Por favor ayúdenme a resolverlo.

la consulta es:

    Origen = Odbc.DataSource("dsn=IWS", [HierarchicalNavigation=true]),

    dbo_Schema = Origen{[Nombre="dbo",Kind="Esquema"]}[Datos],

    Ges_OrdenesCompra_Table = dbo_Schema{[Nombre="Ges_OrdenesCompra",Kind="Tabla"]}[Datos],

    Table.SelectRows = (Ges_OrdenesCompra_Table ,   cada [dato] >= #datetime(2022, 1, 1, 0, 0,0)), 

    Table.SelectColumns = (Filas filtradas, {"VendAccount", "VendName"})

    columnas filtradas

[Anonymous · Accepted solution]

Hi @Alexis_Sawyer ,

For the error message for the information you provided, the error "RightParen token expected" in the comma marked in red is due to a syntax issue in the Power Query query. In Power Query, the Table.SelectRows function expects the second argument to be a logical expression, but in your query, you are using commas instead of logical expressions.

You can create a new variable called FilteredColumns that will be used to select the desired columns, so that the changed code looks like this.

Origen = Odbc.DataSource("dsn=IWS", [HierarchicalNavigation=true]),
dbo_Schema = Origen{[Nombre="dbo",Kind="Esquema"]}[Datos],
Ges_OrdenesCompra_Table = dbo_Schema{[Nombre="Ges_OrdenesCompra",Kind="Tabla"]}[Datos],
FilasFiltradas = Table.SelectRows(Ges_OrdenesCompra_Table, each [dato] >= #datetime(2022, 1, 1, 0, 0, 0)),
ColumnasFiltradas = Table.SelectColumns(FilasFiltradas, {"VendAccount", "VendName"})

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.