Forum Discussion
Editing window lost: PowerBI automatically prohibits changes in SQL Code
This change in behavior will ultimately benefit you. PBI now support folding on top of SAP HANA native queries, and you will most likely see improved performance and additional scenarios unlocked.
The missing cog will be fixed in PBI desktop November 2022 version.
It is preferable to stay on PBI desktop August version to edit easily select statements.
While using PBI desktop September 2022 version it is neccessary to update On-premisses Data Gateway to at least August 2022 version and you can use the workaround mentioned above.
My personal recomendation is to upgrade gateway and stay with PBI desktop August version till November version is released.
This change in behavior will ultimately benefit you. PBI now support folding on top of SAP HANA native queries, and you will most likely see improved performance and additional scenarios unlocked.
The missing cog will be fixed in PBI desktop November 2022 version.
It is preferable to stay on PBI desktop August version to edit easily select statements.
While using PBI desktop September 2022 version it is neccessary to update On-premisses Data Gateway to at least August 2022 version and you can use the workaround mentioned above.
My personal recomendation is to upgrade gateway and stay with PBI desktop August version till November version is released.