OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source.

[vfx661]

Sourcing data from snowflake using a native query built from m parameters, using folding:  
df = Value.NativeQuery(db, qry, null, [EnableFolding = true])

In power query it works fine and the data is visible.  However when I switch to power bi it gives me this error:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression.

I've set the parameter values in power query to be the same as that coming from power bi. 
Why am I getting this error?

[lbendlin]

Don't forget there are at least four different query engines in play

- Power BI Desktop

- Dataflows

- Gateway

- Power BI service

Versions are rarely in sync, and it is very likely that the query plans differ ever so slightly across these implementations.  Stuff that "still works" on the desktop may be considered a bug, is "fixed"  on the service, and will then result in a slightly different experience etc.

[vfx661]

To clarify - power query is the one 'attached' to power bi desktop - so I was thinking they'd be the same engine?

[lbendlin]

All four of them (five if you count DFgen2) use Power Query, and they can all be different.