Dataflows SAP HANA SQL Statments disappeared

[fhoerbe]

Hello there,

I've been using dataflows to conect to my organanization SAP HANA database directly with SQL statments for about 4 months now.  This week when I tried to open one of my dataflows in order to perform some alterations I've noticed the SQL statments in all dataflows had disappeared. 

Stangely enough the dataflows still update correctly and have the correct information in them, but due to the SQL statments not being in the M script when I try to edit I can't make any alterations because of the error messages. I've tried to insert the statment again manually in the editor but as soon as I hit 'ok' the statment dissapears again. When exporting the .JSON file the SQL statment is still there so I believe this is a sort of visual/interface bug.

Has something similar happend to anyone and is there a workaround? Thanks in advance

[v-eachen-msft · Accepted solution]

Hi @fhoerbe ,

Power BI Dataflows users may experience issues saving queries with SAP HANA data source. As a workaround, you could add parentheses around the function defined inside the query. Engineers are working on a fix and expect it to be deployed by end-of-day 2/2/2020.