none
Appending Manual Data to Power Query Table RRS feed

  • Question

  • Hello, I am using Excel's power query to pull information from a Salesforce report into an Excel table (and pivot table).  The key column is an 'Account Name' which all the rest of the data is associated with.  There is some information I would like to include that is NOT populated in Salesforce and will need to be updated manually on a quarterly basis in Excel.  How can I include columns in the Power Query table that can be manually entered and not deleted/moved when I refresh the Salesforce connection?  Right now I can add a column to the table and populate it with manual data, but when I refresh the connection the data value suddenly moves to another, seemingly random, row.  Let me know if anyone has seen this.
    Tuesday, September 3, 2019 2:52 PM

Answers