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" .

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I have similar issue.  After trying "Right click Navigation in Applied Steps and choose "Insert Step after", I could not see anything where I could add custom step with filter, but a item called "Custom1" created in "APPLIED STEPS".  If I right click on "Custom1", there is nothig I can edit!

 

Not sure what I missed.

 

Best regards,

Yong