Dataflow - not refreshing

[ShefaliDas2021]

Hi,

We are trying to create dataflow connecting CRM datasource with incremental refresh. When we change the field in CRM, the dataflow did not refresh. But if we go inside the dataflow , save it and close it; only then the refresh happens. What i do not understand is there is no structural changes in the datasource, then why we need to save and close it everytime. 

Please find what have we done in steps :

1. Create a Dataflow with the Source from Microsoft Dynamics.

1. Filter the table only to one row to get an simple overview
   

1. Activate the incremental refresh
   
2. Create a dataset with the connection to the dataflow.
   
3. Change the data in the CRM, in this case I changed the probability to 10%  
4. Manuel refresh the Dataflow
5. Check the value in the dataflow, as expected  10%

1. Manuel refresh PBI desktop, the probability value doesn’t change to 10%,
   
   
2. The same effect in the PBI report
   
   

[v-jianboli-msft]

Hi @ShefaliDas2021 ,

According to the picture you showed above, it seems that the value shown in the table is three times the actual value:

This may be caused by the way of aggregation, in fact your data has been refreshed. Please check how this value is aggregated, and select Don’t summarize.

Best Regards,

Jianbo Li

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