September 13, 2018
I am new to power query. I have a reference table in database that I want to pull into excel thru Power Query whenever I want. I can add in new reference codes and also update existing.
Is it possible that once I load all the records into excel, change/update/add new record in the excel, then create a function that truncates the table in database and load it after wards with all the changes that I did in excel?
Would really appreciate if you would guide me the steps or if you have any relevant link (tried find but din't noticed anything similar).
July 16, 2010
You can add columns to a Query Table that has been loaded into the Excel sheet, but not rows. If you're wanting to add/modify rows then I would do this in a separate table in Excel and then also load that to Power Query and merge the two tables; i.e. merge the one from your database and the one containing your changes.