Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Editing window lost: PowerBI automatically prohibits changes in SQL Code

Hi,   I use the HANA Connector to get Data from our SAP HANA system. This Connector works with SQL Queries. It is (or better to say was) possible to change the SQL code within the window that opens...
Need Help
  • hokeson's avatar
    hokeson
    3 years ago

    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. 

venudharm's avatar
venudharm
Frequent Visitor
3 years ago

I too am facing this issue. Report fails to refresh in service with "Native queries aren't supported by this value" error. I could see that prior versions of desktop <=aug2022 working fine without value.nativequery()