Forum Discussion
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...
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" .
Aaah it’s that easy 😊 Thank you very much artemus , that was exactly what I was looking for!
Best regards
Bas