Issue - Hana Connector's auto Native Query conversion fails for Procedural statements

[ShankarS]

Since Oct-2022 Power-BI Desktop release, the Hana connector seem to be converting SAP Hana queries into Native Query folding automatically and throws an error if the query entered happen to be a Hana SQL Procedure and not a simple SQL.

In these scenarios, we have to then open the Advanced editor and manually remove the Native Query folding statements to get it to work.

Instead the Native Query Folder should be enabled / disable thru an option in the Hana Connector itself OR at the report level.

[v-xiaoyan-msft]

Hi @ShankarS ,

Please try edit data source credentials and cleare permission to see if you are still facing issue.

If this doesn't work, would you mind providing some more details like error messages?

Best Regards,
Community Support Team _ Caitlyn