Forum Discussion

HaNguyen97's avatar
HaNguyen97
Frequent Visitor
2 years ago

SAP HANA data's inconsitency

Hello,

 

I have a SAP view datasource, when I just select *, the data loaded into PowerBI is always 10 times double the real data in SAP.

For example, there're only 1M rows in SAP, but the data loaded into PowerBI is showing 10M.

But when I do the aggregation, for instance, select count(*), the result is matched.

Does anyone face this kind of issue? Any idea will help.

 

Need Help

2 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hello HaNguyen97 ,

    Can you please check if there are any nulls or blanks in the table that you created in Hana. Usually there wont be but that may be one of the reason for this type of issues. 

     

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

    • HaNguyen97's avatar
      HaNguyen97
      Frequent Visitor
      2 years ago

      Thanks for your suggestion.

      But when I try to add the not null condition, the result is still 10M.

      "Select * from a" return 1M

      "Select * from a where Id is not null" return 10M.

      Do you have any idea on this?