Forum Discussion
Power query: how to add (manual) data that doesn't disappear when refreshing.
I am trying to use powerquery to make a holiday planner for our team, but I encountered some problems. The idea is that we can add new/remove colleagues in a team members table, refresh the query and...
MeikeR I'm not an expert, but here's my take on at least part of your question. When you merged the two tables to generate the Team/Date query, you just made a largely blank query. You then entered data inside the blank query, which is possible, but doesn't change the underlying query. When you update the Team table, the query automatically regenerates as blank, because that's all the data it has in the original tables. If you used the Team/Date query area as a new query source, the new query would include any data you had typed into the Team/Date cells.