how to stop refresh removing field entries.

Question

When I enter or update a comment in the comment field and perform a refresh the comments that I entered are removed. How I write entries in the comment field. I create a query called comments and enter the comments in the output and then create another query to pass the comments back to the original output. This is very exhaustive and very manual when I have to copy the output manually and pass it back. How can place an entry in the comment field and not have it removed when I refresh?

Answer 1

Hi,

Did you mean the Comments column in the table always be removed after refreshing the Power Query data?

Did you try to merge the Comments query in Power Query?

https://learn.microsoft.com/en-us/power-query/merge-queries-overview

After merging queries, load the table.

If my understanding is incorrect, please provide more information about your problem.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.