none
Cannot pull more than maximum 20 excel files with Power query RRS feed

  • Question

  • Hi,

    I'm using the From file-->From Folder to pull data from about 60 excel files but only the first 20 excel files will show up in the window. All excel files have the same format in the sheets. I tried also to pull excel files from another folder but only the first 20 shows up. Any idea?

    /Peter

    Wednesday, June 6, 2018 9:05 PM

Answers

  • There is a limitation in the preview-window, but once you load them to the datamodel or to the sheet, they should all show up.

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Thursday, June 7, 2018 6:33 PM
    Moderator

All replies

  • There is a limitation in the preview-window, but once you load them to the datamodel or to the sheet, they should all show up.

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Thursday, June 7, 2018 6:33 PM
    Moderator
  • Hi Kopparsnoken,

    did any of the provided solutions solve your problem? 

    Then please mark it as answer, as it will help others to find a solution to a similar problem. Thx!



    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Wednesday, June 27, 2018 8:53 PM
    Moderator