Forum Discussion
SQL scripts boxed in Value.NativeQuery automatically
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
Dear Pete，
Thanks for your reply.
I tried to delete all these Special characters like '#(lf)', '#(cr)' in Advanced Editor, data can be excuted but I still cannot find the Settings option Window under the Applied Steps to edit the SQL code.
This is very inconvenient for us if we need to view or modify SQL scripts.
Besides, we are using the Power BI Report server. There are other problems with the May 2022 version, so it is not suitable for us to rollback to the previous version.
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
Dear Pete,
Thanks for your reply.
I will consider it according to the real situation, thank you so much