+ Reply to Thread
Results 1 to 4 of 4

Power Query Not loading all Rows from Source File

  1. #1
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    Power Query Not loading all Rows from Source File

    Hi,

    I'm trying to set up a Power Query in Excel 2010, and the query is not loading all of the rows from the source file. The source file has about 2800 rows, and the query is only loading about 240. Any ideas on what could be causing this? I should note that within the same Excel file, I have 2 other queries, and neither one of them have any issues with loading the full source file. In fact, two of the queries are more or less copies of the first one, with a couple slight modifications.

    Thank you.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Power Query Not loading all Rows from Source File

    Hi,

    Are you loading a sheet or a Table?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    Re: Power Query Not loading all Rows from Source File

    It's a sheet.

  4. #4
    Registered User
    Join Date
    06-29-2017
    Location
    Los Angeles, CA
    MS-Off Ver
    2010
    Posts
    43

    Re: Power Query Not loading all Rows from Source File

    My apologies, the file is loading properly, it's just the end result is heavily filtered from the query steps I put in. There is no issue.

+ 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. Replies: 11
    Last Post: 08-01-2017, 06:08 AM
  2. Replies: 7
    Last Post: 07-25-2017, 08:38 AM
  3. Power Query from Excel source file takes too long
    By MrChipper in forum Excel General
    Replies: 10
    Last Post: 06-28-2017, 04:47 AM
  4. [SOLVED] Adding Missing Dates To A .CSV File Via Power Query?..
    By Ourkid123uk in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 03:54 PM
  5. Dropbox Data Host/Source for Power Query
    By mielkew27 in forum Excel General
    Replies: 0
    Last Post: 04-09-2017, 11:49 PM
  6. Remove Unique rows in Power Query
    By danielmorrison in forum Excel General
    Replies: 2
    Last Post: 03-11-2016, 09:06 AM
  7. Power Query how do i reuse on a new file
    By thorrrr in forum Excel General
    Replies: 3
    Last Post: 05-03-2014, 02:07 PM

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