Forum

Power Query Output ...
 
Notifications
Clear all

Power Query Output + Manually added Columns. Out of sync after refresh

2 Posts
1 Users
0 Reactions
232 Views
(@marsha_root)
Posts: 2
New Member
Topic starter
 

I have 8 rows of imported data.  Data source is a combination of 4 files.  This is the Power Query.

I load to a sheet, then add 9 additional rows with related information.  All lines are in sync.

After refresh of the Power query, the 8 imported rows process additions and deletions.  The 9 manually added rows are no longer in sync with the data from the import.  Account A imported data is no longer in sync with Account A manual data. 

 
Posted : 22/06/2019 12:20 pm
(@marsha_root)
Posts: 2
New Member
Topic starter
 

Solved.  This solution worked perfectly if anyone else is having the same issue.

How can I add a new column to the workbook so data can be entered in addition to the results loaded by Power Query?

 
Posted : 22/06/2019 7:23 pm
Share: