Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Query Folding - disable?

Apparently, with the latest update, every time I enter a new query or even edit an existing query, Power BI automatically adds allow query folding = true.  I don't even know what query folding is, bu...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi Anonymous ,

     

    After researching and testing,I am afraid that you could not turn off query folding currently.
    However, you could vote for this idea which is similar to yours. Maybe it will be a feature of Power BI in the future.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

It is possible to turn 'Folding' off!

Go to 'Edit Queries' and in 'APPLIED STEPS' click on 'Source'.

Then click in the command line (starts with 'Value.NativeQuery(' etc. and scroll to the end of the statement.

You'll see: '[EnableFolding=true]', change it to false.

That's it. Succes!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous - I have written custom queries and native query is not available for all of my tables.  I can remove the section on query folding using the advanced editor, but it reappears with every minor change I make to my query.  I can change it to false in the advanced editor, but this does not seem to apply to Power BI Service when I upload the workbook.

There are workarounds to this issue, but they are very annoying.