Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Apply a filter to data from Bigquery when navigating to the table

Hello, I've connected to Bigquery using PowerQuery. When I try and connect to a table it's asking me to apply a filter on the date.        DataSource.Error: ODBC: ERROR [42000] [Microsoft][BigQ...
Need Help
  • artemus's avatar
    artemus
    5 years ago

    Right click Navigation in Applied Steps and choose "Insert Step after". Then add a custom step with a filter. E.g.

    = Table.SelectRows(#"Previous Step", each [Merchant] = "testmerchant")

    Replae #"Previous Step" with the text that is generated by default when you do "Insert Step After" .

artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Right click Navigation in Applied Steps and choose "Insert Step after". Then add a custom step with a filter. E.g.

= Table.SelectRows(#"Previous Step", each [Merchant] = "testmerchant")

Replae #"Previous Step" with the text that is generated by default when you do "Insert Step After" .