Data Update Error (Adds the data many times)

[Syndicate_Admin]

Hi everyone, I need to raise the following topic, as I have not been able to find the solution to my problem.

I tell them to develop a financial model, which considers the budget for the year. The connections I have in my model are: Sap for the actual information and an excel for the budget information.

Now, this load in the power bi service, I do it through incremental load and when the system updates the signature, it adds up many times the information of the budget (information in excel).

I share what the power bi service throws at me.

The correct information and that is in excel is as follows

Specifically, what Power Bi web is calculating for me is adding 38 times the data found in the excel file.

The weird thing is that when I update my model in power BI on the desktop, I don't have this problem, it's just generated in the web service.

[lbendlin]

Show the piece of your Power Query code where you apply the RangeStart and RangeEnd filters.

[Syndicate_Admin]

RangeStart

RangeEnd

From the editor

I have the following query, the date range with incremental load is at the end of the query, by this I mean I have queries appended after the RangeStart and Range End condition.

[lbendlin]

Your parameters look good. Now show the query where you use them.

[Syndicate_Admin]

Exieten queries based on SQL connection and excel file

Both consultations were consolidated and annexed in a sheet called consolidated

Now the report in the web service throws me

January, it adds two months to the values, February gives it to me correctly and from March to December it doesn't give me values.

In summary, the information in ppto 24 is only read for the months of January and February (January adds the values twice and February correctly)

Filter from March to December

[lbendlin]

Your filter is wrong. Only RangeStart should be inclusive. RangeEnd must be exclusive.

each [RefDate] >= RangeStart and [RefDate] < RangeEnd

[Syndicate_Admin]

Change and review the filters, [RefDate] >= RangeStart and [RefDate] < RangeEnd

And now the result is that January is right

But from February onwards I don't get any information from PPTO 24

Could it be related to the fact that I don't have data as real 2024?