Forum Discussion

russellya's avatar
russellya
Regular Visitor
3 years ago
Solved

HANA Advanced SQL statement being changed to NativeQuery. Unable to edit SQL directly

Hi All,   Half of our team are now on the September 2022 patch and the others are on August 2022.  Those of us on Sep 2022 can no longer directly edit Advanced SQL.  We are pushed to the advanced e...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi russellya ,

     

    This issue has been submitted internally.（Internal ICM ID: 339515871）

    The workaround is removing the Value.NativeQuery() from the source M query and using the old way with SapHana.Database().

     

     Please be patient to wait for fixing. If there is any news, I will update it here.

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

GaryOJ's avatar
GaryOJ
New Member
3 years ago

Thanks for the update. I'm glad people are reaching out to Microsoft about this.

 

My scheduled refresh has been broken ever since this change happened as well. Has this happened to anyone else?

 

An error returns almost immediately when trying to refresh in the Power Bi Service. Stating "Native Queries aren't supported by this value" 

 

 

Anyone know why? I need my reports automated or it's a waste of money. Seems like everything has broken down since this update 😞

russellya's avatar
russellya
Regular Visitor
3 years ago

Hi GaryOJ,

 

This is the second symtom of the issue.  The soultion is to apply the fix TheCreeper1 mentioned to each query that was changed.  Then re-publish.  It's can be trciky but it works.  

 

2nd choice is to intall the pre-spetember patch version and rebuild the queires.  

 

I've been told Microsoft product team have an internal ticket to fix this but that may take a while.

 

Regards

Russell