Forum Discussion

Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago
Solved

Connecting to SAP HANA

Hello all,   Any have experience with connecting to SAP HANA? Our models were working fine until the last two updates (June '17, July '17).   Managed to roll back to the May '17 build but still g...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi Aron_Moore,

     

    The PG team has investigated the same issue and suspect the error to be coming from HANA driver as no changes had been made in Power BI. To understand the issue better could you also provide a desktop trace while accessing the report both using the Power BI desktop July and May versions? You can enable tracing on the Diagnostics tab of the Options dialog.

     

     

    VP As your issue is different from this thread topic, please create a new thread in desktop forum.

     

    Best Regards,
    Qiuyun Yu

  • Aron_Moore's avatar
    Aron_Moore
    8 years ago

    Looks like we finally have a solution. Seems we need to set the calculation views to Data Category: Dimension for the HANA connector to work properly. I can't find where it says that in the Microsoft documentation and am waiting for a reply.

VP's avatar
VP
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

I have similar issue plus

 

-I do not see all HANA datasource using Power BI after latest update.

-I can see all data source using Excel > SAP HANA Database

 

VIvek Patel