Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Null values in my fields when using SAP HANA as Data Source

Hello experts and community . I'm relatively new to Power BI and I'm trying to create a report in Power BI using as Data Source SAP HANA . When I connect the data base I have no issue and I can visualize the calculated views and different fields. BUT when I start to bring the information to the report there are some fields in which all the values are filled with null instead of its real values. In HANA I can see that the fields have information, but it keeps appearing null... It happens with some of the fields, others work just fine.

 

Some that doesn't work: 

 

 

A case in which everything is fine:

 

 

If you have any idea of what is happening, please write back 😞

Thank you!

 

Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

    Please clear data cache in your Power BI Desktop. 

    Which version do you use? Please try with the latest version.

     

    If the issue is still there and you are a paid pro user, I suggest you to create a support ticket to get further help.

     

     

    Best Regards,
    Icey

     

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

2 Replies

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

    Please clear data cache in your Power BI Desktop. 

    Which version do you use? Please try with the latest version.

     

    If the issue is still there and you are a paid pro user, I suggest you to create a support ticket to get further help.

     

     

    Best Regards,
    Icey

     

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

  • bmajcherczak's avatar
    bmajcherczak
    Frequent Visitor
    8 months ago

    same problem here . 

    we are getting info from Sap Hana/  Description Attributes are displayed as NULL even in the preview of PowerQuery.  I've been looking in many forums but no solution yet.

    We have the Hana Client tool latest version (hanaclient-2.26.25-windows-x64)  .

    Descrptions come out null when it's fully visible in HANA.

    It's also visible in another Query tool separated from Hana and another BI TOOL .

    So the trouble is specific to the bonding between Sap Hana & PowerBI Desktop. (November version )

     

    Contacted the support already, yet no solution