Forum Discussion
Incremental Refresh and hard deleted values
Hi all,
I configured an incremental refresh for an odata table.
The table basically consists of the following columns:
Unique_Row_ID | item_ID | Name | Year | amount | last_updated
Now unfortunately removing the amount for one year in the Applikation Front end will delete the row in the database.
There are now two scenarios:
Before deleting the entry the last_updated was in my range for the incremental refresh
Or
It was historic data already couple of years old and didn't change recently.
Is there a chance that the incremental refresh will remove the data from the dataset as well? Or do I need to go back to full load (which takes pretty long) and leads to issues when done several times a day.
Thank you for your help
Markus_G - The historical or achive data will be updated based on the incremental refresh policy you set up. So for the historical data that is deleted, it might take some time to reflect in the dataset.
It will be better for you to refresh the pbix file in desktop, update the incremental refresh polciy and publish to Power BI Service.Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !
1 Reply
Markus_G - The historical or achive data will be updated based on the incremental refresh policy you set up. So for the historical data that is deleted, it might take some time to reflect in the dataset.
It will be better for you to refresh the pbix file in desktop, update the incremental refresh polciy and publish to Power BI Service.Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.
Also, I would ❤ Kudos if my solution helped. It is a token of appreciation!
Thank you very much !