Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

ShankarS

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

Submitted by on ‎01-27-2023 12:34 PM

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.

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎01-29-2023 10:34 PM

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

Idea Statuses