Forum Discussion

Simonawu's avatar
Simonawu
Frequent Visitor
3 years ago
Solved

SQL scripts boxed in Value.NativeQuery automatically

Dear All, We upgrated the PBI desktop from Jan 2022 to Sep 2022 Version this month, When we edit data in power query, we found that the SQL query scripts would be boxed in Value.NativeQuery automati...
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    If you really want the cog back instead of just using Advanced Editor then, near the end of the Value.NativeQuery code, you should see an argument like '[EnableFolding=true]'. If you delete this, you should get the cog back.

    However, I'd strongly recommend that you keep folding enabled for obvious reasons, and just use the Advanced Editor to edit your SQL as required.

     

    Pete