Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Scheduled update failed

Good morning, I have a calculated column away from two others, imagine, column one "Sales", column two "Purchases" the calculated column is "Benefit" which is the subtraction of "Sales" minus "Purchases", I drag it to the report and everything correct. I publish the report in the area of my colleagues (pro licenses like mine), it is displayed correctly, even there everything well.

I have a gateway to the server where the database is successfully connected according to Power Bi.

The problem comes when I schedule an update, when this update happens I am debunped by the results, that is, if a result in the table "Benefits" gives us 20.00 euros because it shows me 2.00.00 .

Can anyone tell me that this problem can be due and how to fix it? Say that I've also taken a look at the Power Bi help documents on the topic of https://docs.microsoft.com/es-es/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios and I really can't find any solutions.

Any help will be welcome.

Thank you.

1 Reply

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Syndicate_Admin ,

     

    Did you modify the data of the data source before the update, which resulted in incorrect results after the update? After checking the update, does the table value in powerbi desktop change?


    If the problem is still not resolved, please provide detailed error information and specific operation screenshot. looking forward to your reply.

     

    Best Regards,
    Henry

     

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