+ Reply to Thread
Results 1 to 3 of 3

Power Query - Getting excel files from folder

  1. #1
    Registered User
    Join Date
    07-02-2025
    Location
    Canada
    MS-Off Ver
    office 365
    Posts
    2

    Power Query - Getting excel files from folder

    I have a query that grabs excel files from a folder. It now contains over a 100 files so it takes a long time to update. Is there a way to only grab any new files loaded? I still need all the files loaded from the folder but am hoping there is a way to update only new files? is this possible?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2508 Win 11
    Posts
    24,959

    Re: Power Query - Getting excel files from folder

    Once you have all the files in PQ Editor what are you doing with them. Briefly explain, please. This would help to understand how to address your issue.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    07-02-2025
    Location
    Canada
    MS-Off Ver
    office 365
    Posts
    2

    Re: Power Query - Getting excel files from folder

    I combine all the excel files into one master file that I then use to create a report page with slicers to show the data from all files matching the filter

+ 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. Power Query - differentiating files to apply action to from a folder
    By SCarroll in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2024, 08:39 PM
  2. [SOLVED] Power Query: Combining files in a folder with different sheet names
    By Mingeita in forum Excel General
    Replies: 9
    Last Post: 01-18-2024, 10:34 AM
  3. Replies: 1
    Last Post: 05-04-2022, 10:35 AM
  4. Power Query, Problem with combine inconsistent column files in a folder
    By Eric Tsang in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 02-11-2021, 07:17 PM
  5. [SOLVED] Power Query error when importing files from a folder
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-02-2019, 10:28 AM
  6. Replies: 0
    Last Post: 01-14-2019, 12:59 PM
  7. [SOLVED] Excel Power Query - Only New Files Using 'From Folder'
    By rabbit_post in forum Excel General
    Replies: 4
    Last Post: 11-12-2018, 06:07 AM

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