The table becomes in next two days after setting Incremental Refresh - Help Required

[Abishek]

Hi all,

When Configuring Incremental refresh in Power BI, Initially it was good. After Two days my table became blank after a refresh. When I verified the parameter was causing the problem. How to solve this problem ? Should the parameter be dynamic ?

Note: I need my data in the table for two years. For example the min-data  = "2021-08-01" and max-date = "2023-08-22", this is the data I need to apply my incremental refresh on. "when the month changes the min-date has to the first data of that month two years before, and max date should be the current date."

This is how my incremental refresh is set. Please let me know what is going wrong.

[Anonymous]

Hi @Abishek 

Please check the following points:

1.If the incremental refresh is failed that cause the table become blank.

2.Please check the paramater, did you use the following function.

Table.SelectRows(step, each [Date] >= RangeStart and [Date] < RangeEnd)

3.Please check if it exists the data in current date, because you set the refresh in 1 day.

Best Regards!

Yolo Zhu

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

[Abishek]

Thanks v-xinruzhu-msft:

Thanks for your solution, my parameters are working correctly. but the actual problem was new data coming through incremental refresh was creating duplicates. because of this my relationship fails and incremental refresh did not do well.

I only need to keep the data coming form the current refresh and delete the old data coming form incremental refresh.

I have tried multiple approach to solve this problem. FInally ended up in thinking of sorting the table in descending of the date column and removing duplicates ID’s will make the refresh smooth and faster. But I could see this causing a query folding issue.

is this a correct way to approach this problem, or is there any other way to do this.

you guidance will be much useful for me.

Thanks.
Abishek R.