Forum Discussion
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.
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.
6 Replies
- lbendlinSuper User
Show the piece of your Power Query code where you apply the RangeStart and RangeEnd filters.
- Syndicate_AdminAdministrator
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.
- lbendlinSuper User
Your parameters look good. Now show the query where you use them.