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

[KCosgrove]

Using Snowflake and DirectQuery.  Previously the file has opened in powerbi desktop and the data model updated without issue.  The file was published to power bi service.  Data refresh on PBI Service failed today.

This error message now occurs when attempting to open the powerbi desktop file "OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..".  We get the option to report the issue or cancel, then the file does not open - so there is no way to fix any query folding issues.

The error message is occuring on this version and all previous versions we have saved of the report in our archive.

Any assistance on how to open the file would be appreciated.

[v-yalanwu-msft]

Hi， @KCosgrove ;

To get faster and better technical support for this issue, If you have Pro account you could try to open a support ticket. you may directly create a support ticket.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KCosgrove]

Thanks @amitchandak, I appreciate the response and link.  I'm confident to be able to fix the folding issue once we get access to the file, unfortunately once the error message appears, the only options are report and cancel.  The file does not open.  

[amitchandak]

@KCosgrove , A new Blog from Chris on the same topic, see if that can help

https://blog.crossjoin.co.uk/2022/05/08/understanding-the-we-couldnt-fold-the-expression-to-the-data...

[zzeng]

This blog is quite helpful.

According to the blog, I created a View to resolve the problem.

Thanks!