Forum Discussion

Smokey24's avatar
Smokey24
Icon for Helper I rankHelper I
6 years ago

Double value after incremental refresh

Hi there,   I have a strange problem that since incremental refreshing the amount of some values have doubled. The incremental refresh is scheduled like this :   Now suddenly the value has...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Smokey24 ,

 

Would you please verify queries have an equal to (=) on either RangeStart or RangeEnd, but not both.

 

If the equal to (=) exists on both parameters, a row could satisfy the conditions for two partitions, which could lead to duplicate data in the model, i.e. the same order to be loaded in the model twice in two consecutive loads.

 

For more details, please refer to https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#rangestart-and-rangeend-parameters

 

Best Regards,

Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks v-deddai1-msft ,

    this did the trick for me!

     

    Best
    Alex