May 14 2023 04:08 PM
Hello! I can add columns to the left of a table hit refresh and that new column stays, why is that no
Thank you!
Josh
May 14 2023 09:02 PM
Hello Josh/@jtaddy1987
I read your issue description a couple of times, though I don't understand
Could you dev. a bit/clarify, provide a bit of context and possibly post a couple of pictures to clarify things?
Also, Excel version? Windows/Mac?
Jun 06 2023 02:12 PM
Jun 10 2023 04:03 AM
Power Query ignores all manually added to the table columns and refresh only the columns with fields it returns. That means if some data in such column it won't be in sync with returned by Power Query records.
Blank row could be added within Power Query. If you need to do some calculations within such row perhaps that could be done in Power Query. Another way that's so called self-referencing tables when you query again returned by Power Query table and merge it with queried new data to keep manually added data in refreshed result. For that you need to have unique ID for each record, which as well could be generated by Power Query.
Above is bit abstract, that's better to discuss on sample file with indication which result is desired.