Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Question about Incremental Refresh

Here is our scenario:    We have data in our CRM system.   Things like sales opportunities, amount, probability of closing the deal, etc.      Normally, these records are overwritten in the CRM s...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

For incremental refresh, datasets are filtered by using Power Query date/time parameters with the reserved, case-sensitive names RangeStart and RangeEnd. These parameters are used to filter the data imported into Power BI Desktop, and also to dynamically partition the data into ranges once published to the Power BI service. The parameter values are substituted by the service to filter for each partition. There's no need to set them in dataset settings in the service. Once published, the parameter values are overridden automatically by the Power BI service.

For more information about how incremental works, the following attached links could also help you to understand:

  1. Incremental refresh document 
  2. Incremental refresh case 
  3. Incremental refresh viedo 

 

Best Regards,
Yingjie Li

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