Forum Discussion

fhoerbe's avatar
fhoerbe
Regular Visitor
6 years ago
Solved

Dataflows SAP HANA SQL Statments disappeared

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

 

Dataflow
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

1 Reply

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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.