HI,
I guess I have a simple question for, which may seems obvious.
I´m currently working on the PQ training and I understand the ways to bring in data to PQ and report them back on an Excel sheet. As well I understand, that I simple cam refresh the data on the PQ report, if the source data has changed.
My question is, if, once I created a PQ report based on a set of data, I can add lines to it manually, which will be kept as well, if I refreshed the data?
If not, the PQ report exist only for reporting purpose, right?
Thx
best regards, Christoph
Hi Christoph,
You can't add rows to a Power Query table in an Excel worksheet and then refresh the query which adds new rows and expect those rows that were manually added to be retained. I hope I understood the question.
If you want to add rows, then add these to another worksheet and then add that data to Power Query as a new query where you can merge it with the original query. This way everything is retained and new data can be added to the original query by way of refresh.
Mynda
