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
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi npowerbi,

 

You can set the proper range as you need. Once the incremental refresh is set up and the file is uploaded to the Service, these two parameters will be overwritten. That means the incremental refresh will take over the range of data and retrieve the new data. Please refer to service-premium-incremental-refresh#rangestart-and-rangeend-parameters and service-premium-incremental-refresh#refresh-ranges.

 

>>>Once published, the parameter values are overridden automatically by the Power BI service. There is no need to set them in dataset settings in the service.

 

Best Regards,

Dale

  • 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