Forum Discussion

vfx661's avatar
vfx661
Icon for Advocate I rankAdvocate I
2 years ago

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

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...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

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's avatar
vfx661
Icon for Advocate I rankAdvocate I
2 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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