Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SAP HANA Connector Forcing as Native Query

So. I've had an issue arise in just the past few weeks, I assume with the latest update and I was wondering if anyone else was having an issue or if there is some workaround.   I connect with the S...
Need Help
hokeson's avatar
hokeson
Microsoft Employee
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 this workaround.

My personal recomendation is to upgrade gateway and stay with PBI desktop August version till November version is released. 

  • user123456789's avatar
    user123456789
    Frequent Visitor
    3 years ago

    Hi there,
    We have June-22 version of the on-premise gateway. Are you saying if we upgrade to Aug-22 version or later then the issue where reports fail to refresh in service with "Native queries aren't supported by this value" error will not occur anymore?

    Thanks

    • hokeson's avatar
      hokeson
      Microsoft Employee
      3 years ago

      Yes, June version does not support nativeQuery for saphana connector. It is supported since August 2022 gateway version.