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.

     

vamsi81523's avatar
vamsi81523
Regular Visitor
5 years ago

1. Load any random table from get data in query editor. eg. select * from aa.b.asdfa such that no folding error comes up

2. Then go to advanced editor and go to last line and turn enableFolding to False. and click OK

3. Go to Source in APPLIED STEPS and double click it.

4. Here we can paste the original query. 

5. Click OK 

wblotevogel's avatar
wblotevogel
Regular Visitor
5 years ago

Your tip got it working.

I just copied it from another report where it worked:

 

 

let
    Source = Value.NativeQuery(PostgreSQL.Database("10.10.256.256", "YourDatabaseName", [CreateNavigationProperties=false]), "select * from whatever", null, [EnableFolding=false])
in
    Source

 

 

 

If you paste this in your advanced editor and put your query where the "select * from whatever" is now it should work.

(You have to change the IP and the database name)

 

Edit:

After I got this working. I got an error about permissions. turned out I didn't had select permission on that particular table/view. So this could be worth checking first.