Forum Discussion

npowerbi's avatar
npowerbi
Advocate II
7 years ago

Incremental Refresh : RangeStart and RangeEnd Values

Experts,   I am trying to implement incremental refresh. I have defined RangeStart and RangeEnd parameters as well. I have already refresh my dataset till today that means I have all the rows from ...
Need Help
npowerbi's avatar
npowerbi
Advocate II
7 years ago

Thanks Dale for your reply. I tried to set up the incremental refresh for HANA as per steps you have provided in the link however I am getting an error for every refresh. Any idea what might be the issue?

 

Last refresh failed: Tue Sep 11 2018 17:02:33 GMT+0530 (India Standard Time)
Cancellation occurred when sending or receiving a request.Hide details
Cluster URI:    WABI-US-EAST2-redirect.analysis.windows.net
Activity ID:    9d34cc72-36fb-4323-80b2-9bbd9a3c02ab
Request ID:    d5ff6e31-8525-4daa-bf61-af082ef3875b
Time:    2018-09-11 11:32:33Z

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi npowerbi,

 

I have found an error message. Please check your Messages for details. 

The database operation was cancelled because of an earlier failure.Description="Column 'P****r' in
 Table 'C******ew' contains a duplicate value 'C**********3' and this is not allowed for columns on
 the one side of a many-to-one relationship or for columns that are used as the primary key of a table."

Best Regards,

Dale

  • npowerbi's avatar
    npowerbi
    Advocate II
    7 years ago

    Thanks Dale, I am hoping that the message you have mentioned is a generic error and not the one I am referring to. Becuase my table does not have any PO number field nor my model has multiple tables.

     

    I am just working on one sample custom table in HANA for incremental refresh and I hope you are referring to possibility of duplicate rows in the dataset. I will check and will let you know. Thanks for the pointer.

     

    Nitin