Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

rsizer

"Query Folding" error after Desktop update

Submitted by on ‎06-17-2024 02:20 PM

Hello.  We are having an issue with new versions of Power BI desktop.  We are using direct query to connect to our data.  Reports that have been working fine for several months are now showing the "query folding" error when we try to run them.  This happens when we updated to the June 2024 release of desktop.

 

This is a pretty big bug as it breaks all our reports.  We were able to roll back to the May version, but I'm worried this will continue to  be broken in subsequent releases.  

Status: Accepted
See more ideas labeled with:
8 Comments (8 New)
Comments
Anonymous
Not applicable
‎06-17-2024 07:11 PM

Hi @rsizer 

Desktop was updated on the 17th and the latest version number is currently 2.130.930.0, you can re-verify that the problem still exists after updating the version.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

 

Best Regards,
Community Support Team _ Ailsa Tao

tescnovonesis
Regular Visitor
‎06-18-2024 09:21 AM

We have the same problem.

Our issue seem to related to Snowflake connection. If we have a table with boolean and filter a table/visual after True/False, then the visual fail.

Also, if a table with Integer is imported, it will be imported as numeric. If this is then converted to Whole Number in the Semantic Model, then visual breaks.

If the model is changed to Import or Dual, it works.

Similar tests is SAP HANA or SQL server did not show same problem.


We tried updating Snowflake ODBC driver to newest, but did not work.

 

So, it seems DirectQuery folding back to snowflake is broken.

rsizer
Frequent Visitor
‎06-18-2024 10:08 AM

@Anonymous   I just downloaded the latest version you referenced.  The error is still ocurring.  

rsizer_0-1718730425339.pngrsizer_1-1718730477982.png

 

Anonymous
Not applicable
‎06-19-2024 07:45 PM

HI @rsizer 

What is the data source you are using? Have you checked some of the commands inside Power Query and there are errors?

 

Best Regards,
Community Support Team _ Ailsa Tao

rsizer
Frequent Visitor
‎06-20-2024 08:36 AM

@Anonymous 

We are connecting to Snowflake.  The Power Query errors are the same as the visual level errors, "cannot fold query".

 

The issue here is that these queries ALL worked previously and only broke with the latest June release.  NOTHING changed in our file or in the Power Queries.  This is a regression.  

 

Like I mentioend in my original post, when we reverted back to the May version of desktop, the errors went away and our reports all function as expected.

Anonymous
Not applicable
‎06-23-2024 07:48 PM

Hi @rsizer 

We have seen on the internal platform that other engineers have reported this issue and submitted it. 

The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient!

 

Best Regards,
Community Support Team _ Ailsa Tao

ngwtaylor
Frequent Visitor
‎07-02-2024 09:24 AM

I was getting this folding error so I removed the relationship and tried to re-add it and now I'm getting a blank values error despite there being no blank values.

ngwtaylor_0-1719937459788.png

 

TDargan
Frequent Visitor
‎04-14-2025 07:02 AM
Hi, Is there any update on this? I'm on the March 2025 release and it's still not working.
Idea Statuses