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.

     

Alex_Ooi's avatar
Alex_Ooi
Helper IV
6 years ago

Unfortunately right now I cannot even load my SQL script because of this. So there is nowhere I can turn it off manually because nothing is loaded into pbix.

rflora's avatar
rflora
Frequent Visitor
5 years ago

This may sound odd but if you remove the semicolon at the end of your query and give it an enter after that so the cursor moves down, it will work.

  • h4ns3n's avatar
    h4ns3n
    New Member
    3 years ago

    Thanks. This solution works for me. 

    Connecting to postgres on AWS RDS. 

     

    I've been using Power BI since 2015 when it was still in beta release and this issue was already a pain to deal with. It seems no matter what we do, the Power BI team will continue doing whatever it can to make connecting to non-MS databases as a difficult as possible. When are you going to realize that cloud data solutions are ubiquitous. Just make Power BI THE platform to get insight and make it possible to connect to all the data all the time as easily as possible.