+ Reply to Thread
Results 1 to 6 of 6

Adding/Updating Data to an existing Power Query

  1. #1
    Registered User
    Join Date
    05-01-2020
    Location
    USA
    MS-Off Ver
    2019
    Posts
    8

    Adding/Updating Data to an existing Power Query

    I had created a power query that got data from a folder. It's transformed the way I like. I thought that if I added new files or changed data within the existing files and refreshed my query that it would update. The only way I can figure out how to add new data is to recreate the query and append the data. I'm sure there must be an easier way and was looking for some direction. Thanks!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,046

    Re: Adding/Updating Data to an existing Power Query

    You must be doing something wrong.

    1. What is the location of the files you want to pull data from?
    2. What is the M code from the query?
    3. Are you refreshing the query?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    05-01-2020
    Location
    USA
    MS-Off Ver
    2019
    Posts
    8

    Re: Adding/Updating Data to an existing Power Query

    Hello, no doubt I am lol.

    1) The location of my files are in C:\Users\xxx\Documents\Excel\Practice\excel_workbooks.
    2) Below is M code
    3) To refresh I click on Data>Queries & Connections...this brings up my query and I right click on it and select refresh. Thanks!

    Please Login or Register  to view this content.
    Last edited by AliGW; 05-03-2020 at 12:24 PM. Reason: Code tags added.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,046

    Re: Adding/Updating Data to an existing Power Query

    I have added code tags for you - they need to be added around code in future, please, as per the forum rules.

    This query looks a bit odd to me. Are you able to share a workbook that is in the same format as those you are importing via the query?

  5. #5
    Registered User
    Join Date
    05-01-2020
    Location
    USA
    MS-Off Ver
    2019
    Posts
    8

    Re: Adding/Updating Data to an existing Power Query

    I figured it out. I had the new file in the wrong (similar) name folder. After I moved the new file into the right folder path, refresh did what I needed. Thanks for the fast replies!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,046

    Re: Adding/Updating Data to an existing Power Query

    That would be it - glad it's resolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Blank cells in Power Query, data existing in original source
    By kirootsouthpark in forum Excel General
    Replies: 4
    Last Post: 08-25-2020, 05:05 PM
  2. Updating a table with new data in power query
    By SueBristow in forum Excel General
    Replies: 0
    Last Post: 04-02-2020, 03:53 PM
  3. Power Query: Updating a query based on changing tables
    By cheesehead101 in forum Excel General
    Replies: 1
    Last Post: 12-16-2019, 06:54 PM
  4. [SOLVED] Power Pivot/Query Convert Existing Table to Query
    By trisoldee in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-23-2019, 04:27 PM
  5. [SOLVED] Adding manual data to a power query?
    By S7ewie in forum Excel General
    Replies: 20
    Last Post: 01-19-2019, 08:44 AM
  6. Replies: 0
    Last Post: 04-05-2018, 01:16 AM
  7. Adding data to the end of a table with Power Query
    By afila in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-14-2016, 08:29 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1