Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SAP Hana Connection Error

So, here is the thing

 

I succefully connected Powe BI to a database in Sap Hana, you can see a table and his values for this example, 

but when I'm in the Edit queries Power BI show me the next message:

 

 

I don't understand why is this happening, why show me an error in the edit queries but i can use the information for create a report, I really need to do certains things, like filter rows and replace some values. I just starting with Power Query, I'm not  good creating M code, I really need to see the data so i can do all the modifications. 

 

Thansk in advanced

Harrinson A.

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      v-chuncz-msft

       

      thanks for your reply, but i'm lost there, why would be an SQL error?, Power BI is the one who made the syntax for the import. :(

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    is this with the December update? I use Hana and it worked fine with the November update, but won't work with the December update.  I get a query too complex error.  Uninstalled the December version and resinstalled November and it works fine.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      thanks @Elka, actually i'm working with the November version, is so strange why I can see data in the report view, but an error on the Edit queries.