Forum Discussion
Newly (Manually) Inserted Row Disappears when Refreshing the Data on Power Query
That's practically the same. With above technique add Customer's Name column. Query resulting table once more, append it to main query and remove duplicates on all fields includes Customer's Name.
Very simplified sample:
Thank you for your suggestion. I went through it and, regrettably, it doesn't seem to address my requirement. I need the self-referencing to work on 'rows' instead of columns (like in the example I have shared above). I wonder if a solution exists.
That's practically the same. With above technique add Customer's Name column. Query resulting table once more, append it to main query and remove duplicates on all fields includes Customer's Name.
Very simplified sample:
The link was in above posts, here it is again https://exceleratorbi.com.au/self-referencing-tables-power-query/
SergeiBaklan Can you provide an example or point me in the right direction
That doesn't work such way. Power Query has no idea about manually added data and doesn't care to sync with the. The work around is self-referencing.
SergeiBaklan no its not self-referencing. The "assigned2" field is a drop-down list using values from a different sheet in the same workbook. When I select an option from the drop down list I would expect the selection to remain for that record after refreshing but it doesn't. The other data comes from sharepoint.
Did you use self-referencing technique as in the link above? Data manually added to the table returned by Power Query is not in sync on refresh, you have to sync such data manually.
SergeiBaklan I have a similar issue that I can't seem to solve. I created the column assigned2 and selected 'JMS' from one of the drop down options for ID 4659. When I refreshed the query it deleted JMS from ID 4659 and added it to line 18. It also rearranged the ID Column.
Idreeesi , you are welcome
- Thank you Sergei. This worked like a charm!
