PowerQuery and add manual data

Hi everyone,

I have a Power Query in Excel that outputs a table with [title] [date].

I need to manually add the Sprint number in an extra column [sprint] to specific combinations, aka "I will work on this this month."

The problem is every time the query refreshes, any manually entered data gets lost or misaligned.

- New rows come with the needed values.

- Row order changes.

Because this table is used by many people, I want them only to add the sprint number, nothing else, no copying data or anything.

I would like to know more about your experiences when data needs to be written infrequently but many times.

I am open to know more for powerbi options direct dashboard too.