Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

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

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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator

      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's avatar
        lbendlin
        Super User

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