Forum Discussion
When Power query loads data, it skips a manual data entry. How to solve it (URGENT)
This one is tough to explain, let me try. I'm importing customer names into a table, via power query. In that same Table, I've attached columns, where I put in Manual product quantities. Every...
Nishkarsh31 You can't just manually add columns to a PQ loaded table and expect PQ to pick up and keep track of the extra columns upon a refresh next time. You need to somehow include the new columns in another query that is then merged with the original one. The link below is to a thread from January 2021 where a similar question was answered. Not very straight-forward and other, but similar, techniques are to be found on the web.