Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Syndicate_Admin
Administrator
Administrator

Data Update Error (Adds the data many times)

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.

George05_1-1706273676029.png

The correct information and that is in excel is as follows

George05_2-1706273860764.png

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.

6 REPLIES 6
lbendlin
Super User
Super User

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

RangeStart

George05_4-1706555647831.png

George05_2-1706555610083.png

RangeEnd

George05_3-1706555624387.png

From the editor

George05_5-1706556299423.png

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.

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

Exieten queries based on SQL connection and excel file

George05_0-1706649396842.png

Both consultations were consolidated and annexed in a sheet called consolidated

George05_1-1706649531799.png

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)

George05_2-1706649730872.png

Filter from March to December

George05_3-1706649803323.png

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

 

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

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

George05_2-1706714020348.png

And now the result is that January is right

George05_0-1706713898311.png

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

George05_1-1706713965071.png

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.