Forum Discussion
Keeping data after refresh
Hi Anonymous ,
I think you will have to store the original data in another place and leave it unchanged. For example my original example data is as follows, stored in excel.
After importing that data into power bi, I choose to copy the whole Sheet A and then select "Enter Data" and create Table B.
Then append Table B and Sheet A, and remove the duplicate values.
So when the excel is updated (delete row2 and add row5), table B will add the new row and keep the deleted row2.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserAnonymous , Are you doing the append of data using these DAX append method
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
No, I am using append in Power Query
v-kkf-msftCommunity Support
Hi Anonymous ,
I think you will have to store the original data in another place and leave it unchanged. For example my original example data is as follows, stored in excel.
After importing that data into power bi, I choose to copy the whole Sheet A and then select "Enter Data" and create Table B.
Then append Table B and Sheet A, and remove the duplicate values.
So when the excel is updated (delete row2 and add row5), table B will add the new row and keep the deleted row2.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.